Not In List question

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

hi to all

I have a combobox whose Limit to List property is set to 'Yes'. When an
invalid entry is made in the combo, I get a standard Access message, "The
text you entered isn't an item in the list.".

My question: how do I suppress this message? I generate my own message in
the combo's NotInList event. But, when this sub ends, I still also get the
standard Access message that I'm trying to suppress. I've tried using
'DoCmd.SetWarnings False', but I still get the undesired message box.

Thank you for any clues
 
Becky said:
hi to all

I have a combobox whose Limit to List property is set to 'Yes'. When an
invalid entry is made in the combo, I get a standard Access message, "The
text you entered isn't an item in the list.".

My question: how do I suppress this message? I generate my own message in
the combo's NotInList event. But, when this sub ends, I still also get the
standard Access message that I'm trying to suppress. I've tried using
'DoCmd.SetWarnings False', but I still get the undesired message box.
Click to expand...


Set the NotInList event procedure's Response argument to
acDataErrAdded if you are adding the new item to the list or
acDataErrContinue if you are not adding the new entry.

See NotInList Event in VBA Help for details.
 
Back
Top