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,
(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,