Update Combo Box for Entry in Another Form

Solar.Paul

Registered User.
Local time
Today, 21:28
Joined
Dec 21, 2013
Messages
20
I can't work out how to update the selections available in a combo box as follows:
I use a combo box in a main form to select a record (yacht)
If it's a new yacht then I use an event linked to a button to call another form to add the new Yacht
On exiting the Yacht Maintenance form I return to the main form
The combo box in the main form doesn't list the yacht i just added unless I exit and re-load the form

I'm not sure of the best way to refresh the combo box selections or main form without exiting.

Your recommendations would be much appreciated
 
Open the form by using acDialog option and under this statement requery the combo:
DoCmd OpenForm, FormName,,,acDialog (this is not exatly the syntax)
Me.ComboName.Requery
 

Users who are viewing this thread

Back
Top Bottom