I have a form where I am running several queries at the press of a button. My second Make-Table query gets the usual 'this table will be deleted' blah, blah, blah. I have the Confirm Action Queries unchecked in the database options, but I am still getting the message. Is there a way to manually suppress such a message?

docmd.setwarnings False

...
...

docmd.setwarngins true


Make sure to turn them back on when you are done running your queries.

Also, using CurrentDb.Execute will skip the messages without having to SetWarnings off and on.

Thanks very much for your quick replies. I knew the problem was simple to solve, but couldn't remember the answer.