How do I turn off the update pop up confirmation box for one form?

A

Azzna

I have a button in Access that when pressed does a series of updates
and inserts into various tables. Right now every insert and update is
popping up a box that confirms the user wants to make this update. I
would like to disable those messages only for this little section of
code. How would I do that in the VBA Code?

Thank you!
 
A

Al Campagna

Azzna,
Use
DoCmd.SetWarnings = False
to turn off the action messages, and
DoCmd.SetWarnings = True
to turn it back on.
Make sure your code is thoroughly tested before applying...

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
A

Azzna

Azzna,
Use
DoCmd.SetWarnings = False
to turn off the action messages, and
DoCmd.SetWarnings = True
to turn it back on.
Make sure your code is thoroughly tested before applying...
Click to expand...

You rock. I have tested the section in question with every possible
variation of data we have seen for the last year. But since this is
all happening in the background, we don't want the end users to see
the update/insert messages. So thank you!
 
Top