On Not In List

[Guest]

In a data entry form, I created a on not in list event in a combo box that
first asks the user if they want to add? If the user clicks yes, it opens a
pop up form to add a new value. The pop up form has a on load event that
populates the field using the Me.OpenArgs function.

Then the user has two command buttons to choose from. If they click cancel
the action is undone and they return to the data entry form. If they click
okay the value is added to the look up table and the pop up form is closed.

The problem I'm having is I can't figure out how to get the combo box to
requery and show the new value. So the user has to cancel out of the record
they're entering, close the form and then re-open it to get the new value to
show up so they can slect it.

Can you help?
Thank you,

 

[Al Camp]

Glenn,
On my website below, I have a NotInList sample file that you can downlaod.
It asks the user if they want to add the new value, adds it, and requeries
the combo to now display that new value.
NotInListCombobox.zip
on my Tips and Tricks page...

 

[Guest]

This worked perfectly. Thank you very much.

Glenn,
On my website below, I have a NotInList sample file that you can downlaod.
It asks the user if they want to add the new value, adds it, and requeries
the combo to now display that new value.
NotInListCombobox.zip
on my Tips and Tricks page...
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions