Msgbox override in Update Query

[PRD]

I created a simple update query which I run from a command button on a form. When I click on the button I get prompted by two Access msgboxes saying that I am about to update records and I have to click 'Yes' on both msgboxes before the query runs (which is rather annoying). Is it possible to override these msgboxes so the query just executes when the command button is clicked? If yes, how can I do this? Thank you for your time.

 

[vapid2323]

DoCmd.SetWarnings False

Just put it before the code.

 

[PRD]

vapid2323 -

Actually I was running the query from a Macro (not a Module) but found the 'SetWarnings' keyword (which I set to 'No') and inserted it just above the 'OpenQuery' keyword and it worked perfectly. Thanks for the help!