how do you supress a confrimation on a query when it is giving a message of setting to null

[sd]

How do you either suppress the confirmation or automate the answer to yes
when a query has a confirmation message due to setting values to null. I
have already unchecked the confirmation boxes in options.

 

[Guest]

If you are NOT running the query from a macro, go to the
Access Tools menu and select Customize. Go to the
Edit/Find tab and deselect "Action Queries" (or "Record
Changes" depending on your specific situation) in the
upper right-hand pane.

 

[JulieB]

Similarly, you can set this property in an Event Procedure
by typing
DoCmd.SetWarnings = No

-----Original Message-----
If you are running your query from a macro, you can:

Set Warnings = No (put this before the OpenQuery action)

Make sure you set your warnings back to yes at the end of

your macro if you want messages to appear during your
database session.