suppressing message box

[MariaL]

I have a form that when it is closed by the user it runs a
macro that creates a table that will append information to
another table. How can I suppress the message box that
ask the user if they want to delete the table when the
query is run? It's not necessary for the user to make this
decision.

 

[Gerald Stanley]

To prevent users from seeing system generated warning
messages, use
DoCmd.SetWarnings False

Hope This Helps
Gerald Stanley MCSD

 

[Chris]

In your macro, add SetWarnings and False.

Or, in code, DoCmd.SetWarnings False

Make sure you turn them back on after you are done.

Chris

 

[MariaL]

Yes it did - Thanks!

-----Original Message-----
To prevent users from seeing system generated warning
messages, use
DoCmd.SetWarnings False

Hope This Helps
Gerald Stanley MCSD
.