subreports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 10 subreports inside the main report. When I open the report it ask
me to enter the paramenter information for each subreport - which is
repetitive. What can I do to limit the times I have to enter the paramenter
information? (The subreport are individual reports from queries which
prompts me to enter the begining and end dates to search for information
during that time frame.)
 
Create a form with some unbound controls where you can enter the limiting
values. Then in the query of each subreport, refer to the controls on the
form.

For example, if you want to limit the subreports to a particular city, you
would type this into the Critieria under the City field in your queries:
[Forms].[Form1].[txtCity]
where "Form1" is the name of the form, and "txtCity" is the name of the text
box on the form.

Provided the form is open, the subreports will all read the value from the
text box instead of continually asking you for the value.
 
Back
Top