Disable Error Messages

[Matt Howard]

On my form I have a list box with names of employees.
When you try to enter a name that is not on the list, I
have a message box come up that informs them of this and
the procedure to follow. What I need is to disable the
default not in list message that Access provides. I use
Access 2003, and I have the following code:

DoCmd.SetWarnings False

I was under the impression that this killed the error
messages but it does not.

Any help is appreciated.

Thanks,

Matt Howard

 

[Jeff Conrad]

I would git rid of the DoCmd.SetWarnings False line.
Add this line of code after your message box and 'procedure':

Response = acDataErrContinue

That will stop the Access message from appearing.
--
Jeff Conrad
Access Junkie
Bend, Oregon
Install the latest Windows Updates:
http://www.microsoft.com/security/security_bulletins/200404_windows.asp

 

[Ken Snell]

In the code that you run on the NotInList event, include this step:

Response = acDataErrContinue

That will bypass the built-in ACCESS message.

 

[Matt Howard]

Thanks, that worked like a charm.

I'm still new to VB and VBA, I'm not sure I completely
understand what that command does.

Matt