Supress Message Box

[DS]

I'm trying to supress a message box on my combobox when a user enters
text not in the combobox. I tried SetWarnings False that did
nothing......I can't figure it out.
Thanks
DS

 

[DS]

I'm trying to supress a message box on my combobox when a user enters
text not in the combobox. I tried SetWarnings False that did
nothing......I can't figure it out.
Thanks
DS

This does the trick! It'll stop Microsofts box and open your own form,
if not get rid of DoCmd. and Change MsgBox to whatever you want.

Response = acDataErrContinue
DoCmd.OpenForm "NotOnList"
'MsgBox "The state you chose, " & NewData & ", is invalid."

DS