Query Criteria

[gothung]

Is there any way that I can show the criteria that a query is filtered on in a text box in a report

 

[Dr_Worm]

Here is one solution:

Create a form where you enter the criteria into text or list boxes and a button to run the query. On the form that shows the results put a text box with with something like this;
="Searched for " & [Forms]![Your Form]![Combo or text02 ]

Hope this helps
Dr_Worm

 

[gothung]

I had my form and filters (there are 5 of them, and they come from combo boxes) set up exactly the way you described. The only problem is that the formula you gave me didn't work. The formula Shows results for all filtered records, rather than just showing me the selections I made. I may only choos 1 of the 5 filters, or I may choose 3 and so on. As a result I want to just see what I selected. All formulas I have tried show me the data in the query. If I go into design veiw of the query, it shows me only the fields that I chose, and the criteria is what I am really after. Any help would be great!!!