Controlling "limit to list" error

[Del]

I want to display my own message when the user makes an entry in the combo
box that is not on the list. I've tried 'Response=acDataErrAdded' without
success. The standard message still appears after mine. Is there any way
besides comparing entry to list in Before_Update event?

 

[ruralguy via AccessMonster.com]

If you want to inhibit the normal NotInList error message then use:
'Response=acDataErrContinue

acDataErrAdded tells Access that the value is now in the list so try and find
it again.

 

[George Nicholson]

Which method outlined in ...

http://support.microsoft.com/kb/197526/en-us
Use NotInList Event to Add a Record to Combo Box

....are you using? Where is your code different?