Combo boxes

R

Rory Christie

How do I get rid of the system warning when a 'not in list' event occurs -
I'd like to replace it with a customised warning. Setwarnings (false)
doesn't do the trick ???
Any help would be much appreciated
 
K

Ken Snell [MVP]

When your code runs to handle the NotInList event, include a line that says
this:

Response = acDataErrContinue

This will suppress the standard warning box.
 
V

Van T. Dinh

You need to use the NotInList Event to display your message and the set the
Response argument to acDataErrContinue.

Check Access VB Help on the NotInList Event / Event Procedure.
 
Top