Changing Query Criteria

[infinitx]

Hi,

How can I change the criteria of a query? For example, I have a Query called qryQuery1. It has the following fields:

Item ID
Item Author
Item Question
Item Classification

I want the user to have the ability to limit the items by, say, Item Author and Item Classification so I would like to have the query criteria change accordingly.

How can this be achieved?

Thank you

 

[Pat Hartman]

A parameter query allows you to specify the value for a field at runtime. If you want to change which field/fields you want to search on, you need to build the SQL string in code. The structure of a query cannot be parameter driven.