Refresh Form After Adding to Combo Box

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

I have a form on which I have several combo box. The form
is based on a tool table. Many of the fields in the tool
table are lookups to fields in other tables that describe
the specs of the tool. On my form for each combo box I
have a command button next to it that opens a form and
allows the user to add a new type of spec. Then the user
closes the secondary form and the main form is still open.
I cannot find a way to refresh or requery the form or
combo boxes so that when the user returns to the drop down
the newly added spec is there. I have tried me.requery on
the main form, I have tried adding refresh code to the
main forms got focus and activate events...no luck. Thanks
in advance for your help.
 
Hi DD,

include WindowMode:=Dialog in openform command. This stops
further processing until form is closed. The next line
after the open form can then requery the associated
combobox.

Luck
Jonathan
 
Back
Top