Update query message; how to keep it from showing

[kptasteve]

I have an update query that clears a yes/no column to allow me to select records to print. When I run the command button to run the query I get the usually message something like "you are about to update 3 records " . I want to make it so I don't have to respond to this each time I use this update query.

Steve Marcum PT
programmer

 

[RobCPA]

Before the code for running the query, place the line:

docmd.setwarnings false


You'll probably want to set the warnings back to true or it will affect the way warnings are given when you run the queries from the main query window.


Rob