Reset a query (1 Viewer)

[Vulcan1500]

I need to have a button in the menu to reset the SEARCH-query. With a button I give access to this query to add criteria for the search. Often these criteria are not deleted, but other parts of the database also use this search. Can one of you help me with this problem?

 

[MStef]

I can suggest next:
Make a template query without any criteria. Copy this query on your query before you make a criteria.

DoCmd.CopyObject, "your query name", acQuery, "Template query name"

 

[Vulcan1500]

Good idea MStef! Easy and effective! Was looking in a totally different direction.....stripping WHERE clause from SQL statement...etc. Thanks again.