Saving query programmatically

[mp3909]

I am confused.



When you programmatically open a query, rerun it and say you want to then close it, if you close it without specifying any parameter for the save option, then does the query close with the changes saved or not?

Is it always best practice to specify a parameter for the save option?

[ranman256]

you normally open the query for the user to see it. When they have finished, let them close it.
a button would be the only code needed to close the query: docmd.close

data is saved automatically when the user moves off the record, or closes the query.
if the user moves columns around, then the system will ask to save the changes, they can do it or refuse.
I see no programmatic way to do it because it wont know the users preferences.

[Micron]

open a query, rerun it and say you want to then close it

Simply opening makes no changes, so what changes are you asking about?