On Not in List Event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that uses a macro to open a custom form to add a new item
to the list. Can I prevent the standard Access dialog box "Item enter is not
in list..." from displaying?

Thanks for your help!
 
Marianne said:
I have a combo box that uses a macro to open a custom form to add a new item
to the list. Can I prevent the standard Access dialog box "Item enter is not
in list..." from displaying?
Click to expand...


Set the Response argument to acDataErrAdded.

See the Help topic NotInList Event for details.
 
I'm not sure I understand your reply...

"Set the Response argument to acDataErrAdded".

Where do we find the Response argument?
 
The declaration for the NotInList event will be something like:

Private Sub Combo0_NotInList(NewData As String, Response As Integer)

Inside the routine, you need a line of code

Response = acDataErrAdded
 
Back
Top