You can use the SetWarnings, but I recommend the follwing instead, becuase SetWarnings will eliminate any response from the database, even an error you may want to see. Where as the SetOption only affects the action queries.
==========
Application.SetOption "Confirm Action Queries", False
DoCmd.OpenQuery "YourQuery"
Application.SetOption "Confirm Action Queries", True
==========
This is the programmatic equivalent to x-s' response. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?