Filter report based on filter on form

V

Van T. Dinh

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).
 

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
Filter within a report 4
Form Filter 2
filter by form 1
change label on subFORM in REPORT 4
Syntax problem for text criteria to filter a report 8
Pulling data to a report based on double filter 1

Top