Parameters and Sub Reports

  • Thread starter Thread starter Amy Johnson
  • Start date Start date
A

Amy Johnson

I have a report with a sub report in it. Both the report
and the sub report ask for the same parameters due to the
queries they were built off of. The information that for
the parameter is a start date and and end date. When I
run the report I am prompted for the dates twice. Once
for the report and once for the sub report. Is there a
way to only be prompted once for the dates? The same
parameter query is used for the report and the sub report.

Any help would be greatly appriciated.

Thank You
 
There are two ways you can work this:

1: Use a VB Function for your criteria instead of the standard parameter.
Create a global function and use that as the criteria.

OR

2. Use a "mini" form to hold your parameters while the report/query is
running. In other words create a bound or an unbound form, then place text
boxes on it to hold your parameters. Your criteria should then refer to the
form -- [forms]![MyReportParameters]![MyCriteria]

Both of these will keep you from seeing the parameters box asked for
twice..... But my last suggestion would be that IF THE FIRST QUERY is calling
the parameter and the second query is calling that query, do you really need
the criteria in both queries?
 
Back
Top