Combo Box unnecessary Not In List event after adding a record

[Guest]

Using a combo box on an Access form, I use seperate forms to add a new record
to the table that my query is based on or edit a record, changing the text of
the combo box to the new value. when I do this and try to move to another
control, the Not In List event always fires, even though the text in the box
matches exactly the new data, which shows up in the dropdown list.

 

[RuralGuy]

Using a combo box on an Access form, I use seperate forms to add a new
record to the table that my query is based on or edit a record,
changing the text of the combo box to the new value. when I do this
and try to move to another control, the Not In List event always
fires, even though the text in the box matches exactly the new data,
which shows up in the dropdown list.

When you exit the cbo_NotInList() code do you leave with:

Response = acDataErrAdded

If not, that could cause the symptom you describe.

HTH