Developer Forum

Same problem.

I have a report that uses an Action query (maketable) and even tho I have
confirmations turned off in the database options, I still get the
confirmation msg that the table will be deleted.

How do I stop that?
The query is the Source of the report and no code is used, except the code
to run the report itself. I'll try setwarnings in the report open code if I
can.

MichaelM

Reply to meself:
I was able to use DoCmd.SetWarnings in the code that started off the
Maketable query.

MichaelM