Rerun Query

[SuperSlick]

I have a report that gets its data from a query. I need the query to run before the report based on criteria based from two combo boxes on a form.

I am stuck, I think I have been looking at this to long. Please help,

 

[Alansidman]

If you build a form that has unbound text boxes that are the criteria for the query, add a command button to run the report based upon the query. When the report is run it will call the query which will use the latest criteria in your form to provide the data to the report.

 

[SuperSlick]

I tried that. I must have donw something wrong. I will try it again. Thanks for the quick response.

 

[gemma-the-husky]

what do you mean - you want the query to run first?

what is the query doing?

a report is based on a query (normally) so what purpose does this pre-query do, in relation to the report?