Combo box accepting new entry

[Sharon]

I am new to Access programming. My problem is I have a combo box that adds a new record to the underlying bound table. When I enter a new record I get "The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items". The dropdown shows the new record. The new record is being added to the table by use of the NotInList event but I cannot exit the combo box. I have tried requering the combo box in the Combobox_AfterUpdate event and the Form_AfterUpDate event. Any help would be appreciated.

 

[Ken Snell]

In the NotOnList event's code, before the subroutine ends, add this line:

Response = acDataErrContinue

See if that eliminates your problem.


--

Ken Snell
<MS ACCESS MVP>

I am new to Access programming. My problem is I have a combo box that

adds a new record to the underlying bound table. When I enter a new record
I get "The text you entered isn't an item in the list. Select an item from
the list, or enter text that matches one of the listed items". The dropdown
shows the new record. The new record is being added to the table by use of
the NotInList event but I cannot exit the combo box. I have tried requering
the combo box in the Combobox_AfterUpdate event and the Form_AfterUpDate
event. Any help would be appreciated.