Force query to SaveAs on Closing

J

Jerry Whittle

A standard query that you run from the database window then close? No.

Ironically you can turn off the warning that you've changed a query and have
it not save using SetWarnings Off. This frequently happens by mistake.

You can also do it in code or a macro with the the Close method.
DoCmd.Close acQuery , "qryCraig", acSaveYes
 
Top