Update Combo Box


T

TL

I have a main form whose source is the "Equipment" table with a "LOTOGroup"
combo box on it. The drop-down selections for the "LOTOGroup" combobox are
created when I open a secondary form "LOTOGroup-Add" whose source is the
"LOTOGroups" table. This secondary form is opened from the main form using a
control button and closed using a control button. Both tables are linked
(LOTOGroups field (LOTO Table) one-to-many LOTOGroup field (Equipment
table)). Question - How do I get the "LOTOGroup" combobox on the main form
to update once I open and enter data in the "LOTOGroup-Add" form? I can get
it to initially update by placing a docmd.requery in certain sections of
either form, but after trying to add data a 2nd time is does not update,
unless i close the main form and re-open.
 
Ad

Advertisements

D

Duane Hookom

If I understand correctly, you need to requery the combo box on the main form
in the after update event of the secondary form.
 
T

TL

Yes you are correct.

Note - The LOTOGroup combo box (LOTOGroup Field from Equipment table) on the
main form is set-up to retrieve its data from the secondary forms LOTOGroups
field from the LOTO table).
 
Ad

Advertisements

T

TL

Would anyone be able to provide the code to requery the combo box on the main
form secondary form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top