Combo Box

[Guest]

I have a subform with a combo box listing provider names. The combo box has
the Limit to List Property set to Yes. If the user trys to enter a name, I
have a message appear that says Double Click to add to list. The macro I
have created is attached to the Double Click property of the combo box. The
macro opens an entry form for the user to enter the information into the
table that is the control source for the combo box. The user then closes the
form. When I go back to the combo box, the new information is not included.
I tried to use the Requery action in the macro, but I receive an error saying
I can't use the Apply Filter action on this window.
I am stuck. I basically want to be able to have the user enter the name of
the provider and if the combo box does not scroll to that name, I want the
user to then enter the name and go back to the combo box and be able to
select it from the list. Any help will be greatly appreciated.

 

[Steve Schapel]

Karen,

Try to Requery the combobox on the Close event of the entry form where
the new name is entered, or else on the Enter event of the combobox itself.