Refresh combo box

[Raul Sousa]

I have a combo box. When the user types a values that is
not in the lookup table, the not onlist event opens
another for in dialog mode so that the user insert the
new value in the look up table.
My problem is that after the second form is closed, the
new value is not yet on the combo box. I need to refresh
the combo box.
How can I do that?

 

[Wayne Morgan]

Have you verified that the new data is getting to the table? If so, since you are opening
the form in Dialog mode the code that opened the form should stop running until you close
it again. In the code that opened the form, you need a line that says

Response = acDataErrAdded

and the combo box should take care of itself.