Combo boxes

  • Thread starter Thread starter Rory Christie
  • Start date Start date
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
 
When your code runs to handle the NotInList event, include a line that says
this:

Response = acDataErrContinue

This will suppress the standard warning box.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SetWarnings Action 1
Access 2007 4
FollowHyperlink warning 1
Delete, Append, Update Counts 2
Output To Method 3
Customise title wording in dialogue boxes 3
Suppress Not In List Warning 3
Not in list warning 2

Back
Top