DoCmd RunSQL (Action Query as a form opens)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if there was a way to make it so the software does not show
the default user input bx saying "hey man you are about to delete 532
records, is that ok?" as my form opens and executes an action query that I
have tied to that event. It is updating a temporary table so I want it to
happen no matter what. I am sure that if I do not fix this it is going to
make my users do a double take and I will get a telephone call...

Thanks for your help!!
 
Use the setwarnings to false

Docmd.setwarnings False
.....runsql
Docmd.setwarnings True

' Dont forget to set it back to true
 
Back
Top