Alex... what does your response mean?  I get the same warning messages as Vicki.   I copy and pasted what your wrote but got an error message.  It doesnt like the word 'code'.  if i take that word out and just have the 2 docmd statements i still get the error messages.  Can you please clarify what you mean by your response?  What do we need to do to not have the error messages pop up.  Thank you

---

Reply from Alex Hedley:

I updated the response to say
[Type your code here]
I assumed you would know "Code" means replace with the code you have used or want to use
You need the SQL statement that would show a message between those two statements since you are say, turn off warnings, run code, turn back on warnings, these are system wide so if you turn them off and forget to turn them back on you will never get any more warnings.