Supress Message Box

  • Thread starter Thread starter DS
  • Start date Start date
D

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 said:
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
Click to expand...

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
 
Back
Top