Filter report based on filter on form

  • Thread starter Thread starter Henrootje
  • Start date Start date
H

Henrootje

How can I easily copy the filter on a form to a report???

TIA Henro
 
You can access the Form's Filter String using:

Forms!YourForn.Filter

and you can use this in the "WhereCondition" argument of your OpenReport
method (provided that all Fields referred in the Form's Filter are also in
the Report's RecordSource).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to apply the form filter on the report? 3
Excel Export Filtered Form Data To Excel 0
Form Filter 2
Filter within a report 4
filter by form 1
change label on subFORM in REPORT 4
Syntax problem for text criteria to filter a report 8
Form Filter 4

Back
Top