How to refresh the list in a combo box..

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

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

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
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


.