make table delete confirmation

  • Thread starter Thread starter Troy
  • Start date Start date
T

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!
 
Rather than calling the macro, use

DoCmd.SetWarnings False

before you run the rest of your code, and

DoCmd.SetWarnings True

after
 
Back
Top