I don't want the Default Error Message for my Combo Box

[Steven M. Britton]

I have a combo box with the Limit to list property set
to "Yes". On the Event tab -On Not On List - I have an
event procedure that displays a msgbox letting the user
know that they have enter an incorrect value and what to
do to correct it. After the click OK, another Msgbox
appears saying that the text entered is not on the list.

How do I get rid of the second "default" msgbox that
arrives after mine???

-Steven M. Britton

 

[Dirk Goldgar]

I have a combo box with the Limit to list property set
to "Yes". On the Event tab -On Not On List - I have an
event procedure that displays a msgbox letting the user
know that they have enter an incorrect value and what to
do to correct it. After the click OK, another Msgbox
appears saying that the text entered is not on the list.

How do I get rid of the second "default" msgbox that
arrives after mine???

-Steven M. Britton

Before exiting the event procedure, include a line that says

Response = acDataErrContinue