set warning off

[bet]

is there a Macro for docmd.setwarning off instead of writing code in module? I can't find the Macro docmd? I am using Access2010.

thanks.

[ajetrumpet]

try clicking the "show all actions" button in the design portion of the ribbon when you're in design view of the macro builder. some of the dropdown actions are surpressed by default.

[bet]

thanks, I thought it would be so easy with such a small task...it still doesn't show up in Macro so I wrote the code in a module.

function warningsoff()

docmd.setwarnings off

end function