Not in list

[dave]

I use a query to populate a combo box. If I enter an item
that is not in the list I then use the not-in-list event
to add the item to the underlying recordset. However,
when I try to close the combo box form I get an error. I
have tried to requery, refresh, anything to get the new
data into the query so that the new item is recognized and
therefore allow the combo box form to close. Can someone
help me with the proper syntax?

 

[Albert D. Kallal]

You can tell ms-access to re-query, and re-load the combo box by setting
Response = acDataErrAdded

Here is a sample:

http://www.mvps.org/access/forms/frm0015.htm