Using same filter for report and subreport

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
 
A

Allen Browne

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