Apply filter to Report

[BeallDon]

Howdy experts!!

I have a form which, using one of a few buttons, i can apply different queries to the form. Such as "All Transactions", "Reconciled", and "Unreconciled". My problem is that when i select the query on the form, i would also like it to requery the Report that i can generate from the form. So, to apply the same query to the form and the report, and to change when i select a new query.

Thanks for any assistance!

 

[BeallDon]

no replies yet? Do I stump the experts?

 

[dhookom]

You stumped the experts by asking this question outside the "Access Reports" forum.

The method I use almost exclusively to apply a filter to a report is to use the Where Condition in the DoCmd.OpenReport method. Your reports and forms should/might be based on queries/tables with no dynamic criteria. You then filter the records down using the Filter property of the form or report.

I have never found the need to create multiple similar queries where the only difference is the criteria.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[BeallDon]

thanks dhookom. I asked this question in this forum instead of the report forum because i figured it had something to do with the coding. Thanks for the info, i will look into it.