Eliminate prompts from RunMacro in VBA

[chadb]

I want to run 7 delete queries when a form loads. I'm using the docmd.runmacro "macro1.name" in VBA on the form load, which works fine, except that it prompts the user with confirmations for each one. Is there a way to eliminate the prompts and just have it auto confirm each one?

 

[nateobot]

DoCmd.SetWarnings False
docmd.runmacro "macro1.name"
DoCmd.SetWarnings True

 

[chadb]

Thanks for the code!