make table delete confirmation

[Troy]

Hello, I have a make table query in a cmd button that prompts me everytime
I use it. I tried calling a macro to set the warnings to no, but it's not
working for some reason. I have the warnings set to no and here is the code
I used to call it in the sub cmdUpdateRecord

DoCmd.RunMacro SetWarnings

Any help would be greatly appreciated!

 

[Douglas J. Steele]

Rather than calling the macro, use

DoCmd.SetWarnings False

before you run the rest of your code, and

DoCmd.SetWarnings True

after