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.
at 11:00 we start setting msgbox for "Are you Sure?" I am automatically getting asked yes/No/Help "You are about to run update query that will modify data in your table." then again "You are about to update x rows". Did I miss a step to make these messages not appear? Should I follow the help instructions to "clear action queries check box"?