Force query to SaveAs on Closing

  • Thread starter Thread starter Craig
  • Start date Start date
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
 
Back
Top