Not In List event

A

APG

Using MS Article ID 197526 August 11,2005, to add a record to a combo box
that has not in list event. The event updates the table, but does not allow
the item to refresh the combo box. It appears the "Response =
acDataErrAdded" function is not being used.

Any suggestions?
 
M

Marshall Barton

APG said:
Using MS Article ID 197526 August 11,2005, to add a record to a combo box
that has not in list event. The event updates the table, but does not allow
the item to refresh the combo box. It appears the "Response =
acDataErrAdded" function is not being used.
Click to expand...


We will have to see the code you're using, but I suspect
that the Not In List procedure completes before the new
record is added. If you are opening a form for users to add
the new record, make sure you specify the EindowMode as
acDialog to suspend the code procedure until the form is
closed.
 
Top