Using same filter for report and subreport

  • Thread starter Thread starter rsosabusiness
  • Start date Start date
R

rsosabusiness

How can I make a subreport use the same filter as the containter
report?
I tried a number of things, but I cannot get it to work.
Cordially,
Robert
 
Some choices:

Option 1
Use the LinkMasterFields/LinkChildFields.

Option 2
Create a form where the user enters the critiera. In both the main report's
query and the subreport's query, refer to the same boxes so they are limited
in the same way. The critiera in the query will look like this:
[Forms].[Form1].[Text0]

Option 3
Use a command button on your form to open the report. In the Click event of
the button, write the SQL property of the QueryDef for the subreport before
you OpenReport.
 
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

Using WHERE clause when launching Reports from Code 4
Access How to prevent subReport from breaking across pages? 1
Subreport Question 1
Clear form value after report loads 1
calculate form control if one of them is blank 2
Subreport behind report data 2
How to Print a Subreport from a filtered search 1
Headers in subreport 3

Back
Top