Not In List question

[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

 

[Marshall Barton]

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.

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.