Requery a combo box

[Alison]

I have a combo box that when an item is not in list, a
form pops up (thanks to eric for the earlier
information). Now, I can't seem to get the combo box to
display the new record that was added. I know I need to
requery, but I'm not sure where to put it and the correct
systax. I've had frustrations with this in the past.

Thanks for the help!!
Alison

 

[tina]

-----Original Message-----
I have a combo box that when an item is not in list, a
form pops up (thanks to eric for the earlier
information). Now, I can't seem to get the combo box to
display the new record that was added. I know I need to
requery, but I'm not sure where to put it and the correct
systax. I've had frustrations with this in the past.

Thanks for the help!!
Alison
.

take a look at Microsoft Access Help topic
NotInList Event - Event Procedures
and also see the Example provided.