The command you're using is the correct one, but you may be using it incorrectly.
You'll need to wrap the code so that you turn off the warnings, and then turn them back on at the end. If you forget to turn them on, then that means you won't get any error messages, even ones you might want.
Formatting tags added by mark007
I'm not sure what you mean by this. Just be sure that you enter the code to turn off warnings in the procedure where you want it, and then save your code.
this only seems to work if I first run it through the Visual Basic editor open in Access.