Supress Confirmation Messages on Update Query 1

[kirstenlargent]

I have an update query that I want to run in the background when a form is closed. It works fine except that it pops up message boxes to ask if I really want to update.
I can turn off the message on MY computer by going to Tools, Options, Edit, and uncheck the Action Query box under Confirm. But that only changes MY settings, it doesn't work when others use the database on their own computer.
Is there some code I could run when the database is first opened that would change this option on other's computers, or some other way to supress the message?
THANKS!!

 

[smedvid]

I think Docmd.SetWarnings maybe something to look at... htwh Steve Medvid
"IT Consultant & Web Master"