Warning Messagebox from MS-Access

[usermj]

I designed a combox and also set the property of 'limited to list' to yes. I also declared the function NotInList with my own message box. But, the MS-Access default warning message box still comes up after displaying my one.

If I turned the property of 'limited to list' to no, it can trigger the function at all.

Does anyone here have any idea on how to turn the system default warning message box off?

Many thanks

 

[RuralGuy]

You need to set the Response to:
Response = acDataErrAdded
or
Response = acDataErrContinue