Opening popup form with NotInList Event

[Brian Langley]

I think this is a macro issue, but it could be the combobox in question.

I have a combo box that looks up a list of vendors. I want the user to be
able to enter a new one, get a popup that allows them to enter the details
and then proceed back to the original form and continue on.

I have a macro set to the box's NotInList event that opens the vendor entry
form successfully and will save the vendor info to the vendor table, but
will not let the user continue on. When I try to tab out of the box after
adding the new vendor, it triggers the NotInList event again.

How do I make the box requery the table that provides the vendor name? I
have tried the Requery action, but can't get it to work properly.

Cheers
Brian

 

[tina]

i think maybe you can't do this with a macro. you *can* do it easily enough
with a VBA procedure, where you have control of how the system responds to
the NotInList event. take a look at the NotInList Event topic in Access
Help.

hth