suppressing a message

[Guest]

hi all

My combobox is set to Limit To List. When there is no match, Access
produces its standard message: "The text you entered isn't...". To give my
own customized message instead, I use code in the NotInLst event.

Here's my problem. When there is a 'no match', my customized message is
given, but it is then followed by the Access standard message. How do I stop
this second message from showing?

thanks

 

[Marshall Barton]

My combobox is set to Limit To List. When there is no match, Access
produces its standard message: "The text you entered isn't...". To give my
own customized message instead, I use code in the NotInLst event.

Here's my problem. When there is a 'no match', my customized message is
given, but it is then followed by the Access standard message. How do I stop
this second message from showing?

Did you use:
Response = acDataErrContinue
Me.thecombobox.Undo

 

[Guest]

thank you. That works perfectly.
--
cinnie

Did you use:
Response = acDataErrContinue
Me.thecombobox.Undo