Need help to save query.

[Acc4me]

I have a filtered form with a button which uses “DoCmd.RunCommand acCmdAdvancedFilterSort” to open a query. This code is in the form’s button on click event. When the query opens, how do I save it for example as QueryX. In addition, with each new filtered records I want to use the button to overwrite the query with the same name without being asked for a new save name. Am I asking for the impossible? Any help or ideas will be greatly appreciated.

Acc4Me

[JeroenMioch]

Try

docmd.setwarnings false
DoCmd.RunCommand acCmdAdvancedFilterSort
docmd.save acQuery "QueryX"

[Acc4me]

Try

docmd.setwarnings false
DoCmd.RunCommand acCmdAdvancedFilterSort
docmd.save acQuery "QueryX"

Thanks for the response. The code "docmd.save acQuery, "QueryX"" doesn't seem to work. When I select the command button, a new query opens as before.