Macro - how to turn off warnings for action queries

[msmithtlh]

I have a macro that runs a series of updates. Now that everything is working correctly, I want to turn off all the warnings that the update queries pop up, so that it will run straight through. I can't find the command to use in the macro. Thanks!!

[pbaldy]

Look for SetWarnings. Make sure to turn them back on at the end.

[msmithtlh]

I know the command is setwarnings, I've used it in older versions of Access, but I can't find an "action" in the macro builder that allows me to set warnings. That is what has me stumped. Thanks.

Never mind. I just found it - it was "hidden."

[pbaldy]

No problem. For future users, there's a Show All Actions button on the ribbon.