Combo Box missing data unless "Refresh" is done....

[DBForms]

I have a form that contains a combo box. The form is
accessible to users in various methods... for example, you
can enter an ingredient code and pull up the form for that
code directly or you can enter a search phrase to bring up
a list of possible entries. If I access the form using
the direct id code -- the combo box entries are listed and
fine.... BUT if I use a search phrase and then put in a
record number in the record locator to go to the form, the
combo box is empty until I do a refresh on the form.
Anyone knows how I can get the form to appear with the
data in the combo box without doing a manual refresh. I
already tried putting the Runcommand Refresh macro in
various events on the property of the combo box. Haven't
found anything that works yet. Thanks!

 

[Jeff Boyce]

A combo box that needs to be "refreshed" needs to be requeried. Do you have
a way to add something like:

Me!YourComboBox.Requery

to the end of the code that you run in your search mechanism?