Access

Hi Andy

You can use the Open Query command in a macro to open a Query. Soyou can open multiple qeries this way.

If you mean that you want to change the criteria values in a qury every time you run it then you need to use Parameter Queries.

In the relevant query you replace the criteria value with a statement enclosed in square brackets. eg:

Replace Criteria

= 12/02/2008

With Statement

= [Please Enter Search date]

When you run the query you always get asked to enter a new search date.

Hope this helps

Carlos