How to refresh the list in a combo box..

[Paul]

I have an "unbound" combo box in an "unbound" form and the rowsource of the
combo box is based on a field on a table. I also assigned the "On NotInList"
event to the combo box to open another form to add the new value to that
table for the combo box rowsource. The problem is when I close the second
form, the new item I just added to the second form does not show up in the
drop list in the first form. How to refresh the combo box in the first form
when I close the second form. thanks

 

[Gerald Stanley]

After returning to the NotInList eventHandler from the
form, do you set the Response to acDataErrAdded before exiting?

Hope This Helps
Gerald Stanley MCSD