Combo box accepting new entry

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.
--
Sharon

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

"Sharon" wrote in message
...
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.
--
Sharon