Subform Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form to populate purchase order information into two tables
(header and detail tables). The form is divided into a form/subform design.
The detail information (subform) needs to have a combobox field to populate
data from another table. I was able to bring the data in successfully, but
it needs to change as a combobox on the main form changes. It works when I
open the form, or the first time I query on the field... but then it stops
working. I know I need to requery and/or refresh, but I can't figure out
which and where. I've tried on the form, on the subform... nothing seems to
work. Please help!

Thanks,
 
You'd probably use the main form's On Current event procedure, and the
AfterUpdate event procedure of the combo on your main form.

HTH,
Brian
 
Back
Top