How do I stop warning messages from displaying?

[Guest_imported]

I have code in a report module that runs a make-table query. Each time the code executes, messages are displayed and I am prompted to click for different options. I want the report to run with no interruptions. How do I do this?

 

[moonlight]

In Menu.... Tools.. Options...Edit/Find. Use the Confirm check boxes to decide what warnings you want to see.

If you want to do it by code let me know

Hope this helps

 

[Guest_imported]

If there's a way, I'd rather do with code.

 

[tlbroadbent]

To disable warning messages use the SetWarnings method.

DoCmd.SetWarnings (False)

To enaable:

DoCmd.SetWarnings (True)
Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot