Help please -- subreport date range

[jwrnana]

I have a report that contains a subreport. The report has beginning and
date parameters. Is it possible for the subreport to search for the same
date range? Right now, for example, I can use the date range June to August
2005 for the report, but the subreport prints with ALL dates.

Thanks in advance,
JR

 

[Duane Hookom]

Would you mind telling us how you "can use the date range June to August
2005 for the report"?

I expect you are using a parameter prompt query or similar. Consider using
controls on forms to limit the records in your reports and subreports.

 

[jwrnana]

Yes, I am using a parameter prompt query.

Can you explain what you mean by "Consider using controls on forms to limit
the records in your reports and subreports." Are you suggesting that I
create a "Form" for each of the reports and subreports?

 

[Duane Hookom]

One form can supply criteria values for multiple reports. It's up to you as
the developer. Martin Green has some tips on using controls on forms at
http://www.fontstuff.com/access/index.htm.

 

[jwrnana]

Thank you.

One form can supply criteria values for multiple reports. It's up to you as
the developer. Martin Green has some tips on using controls on forms at
http://www.fontstuff.com/access/index.htm.