Subform Population

• Steve F.

  Mr or Mrs. 500

  Points: 587

  More actions

  September 9, 2008 at 11:49 am

  #75313

  I have a main form using a Customer table, and a subform using a CustomerDetail table. Customer is one-to-exactly-one with CustomerDetail.

  Let's say, for the sake of simplicity, my CustomerDetail table has just a CustomerID and a single bit field. My subform then uses Customer Detail as the source, and the main form and subformed are bound on CustomerID.

  The problem: My CustomerDetail subform only displays a checkbox that allows the bit field to be set. However, when I insert a new record on the main Customer form, the CustomerDetail subform is literally empty.

  I tried using an After Update event on the Customer form to insert a CustomerDetail record and then I requery the subform. This is not very nice because the subform remains blank until I click on it, causing the Customer record to insert. This is a very ugly solution.

  What do I do?

• edi rosadi

  Grasshopper

  Points: 15

  More actions

  September 10, 2008 at 3:36 am

  #869472

  hi,

  add this after requery:

  me.refresh()

  regards,

  edi