Unbound Search Combo Box Requery - Not Working Help Needed Please

Geezer

Registered User.
Local time
Tomorrow, 09:26
Joined
Jul 14, 2008
Messages
62
One form two search combo boxes created with the wizard which finds a record on the form based on the value selected in the combo box.

Combo box works a treat. However, when I add a new record the combo box list does not update with the new record. It does if I close the form or put it in design mode and reopen it.

I've tried Me.ComboBox.Requery, no luck. I either get error messages or blank lists!

Also, I have a subform with one field which runs off a query finding a max value for all records. I'm unable to refresh this value to the updated value, I'm guessing solving one issue will solve for the other too.

Any ideas as to what I'm doing wrong?
 
In the form after update event put something like:

me!mycomboname.requery
 
Luck at last

Thanks Ken,

I was trying to run the requery in the after update event of the control, which wasn't working.

I've since added it to the form after update event and added a save button.

Thanks a lot.

In the form after update event put something like:

me!mycomboname.requery
 

Users who are viewing this thread

Back
Top Bottom