Multiple Subreports

[AC_Firefighter]

I have a single monthly report with 10 subreports. Each subreport gathers
distinct data from seperate querries, but all need to be based on the same
month. Currently I have to enter the month for each subreport every time the
main report is opened (10 times). Is there a way to enter the date once and
have it apply to all the underlying querries for each subreport?

Thanks from Northern California

 

[Larry Linson]

I have a single monthly report with 10 subreports. Each subreport gathers
distinct data from seperate querries, but all need to be based on the same
month. Currently I have to enter the month for each subreport every time
the
main report is opened (10 times). Is there a way to enter the date once
and
have it apply to all the underlying querries for each subreport?

Almost sounds as if you are using parameter queries, each of which is
requesting the month.

If you specify the month in a form that initiates the report, each query can
refer to the form in its Open event and modify its Record Source.

Even better, if you have the month in a Control on the main Report (doesn't
have to be visible), you can specify it as one of the Link Master Fields and
Link Child Fields, and you won't have to mess around with code at all.
(Unlike in a Form, just having it in the RecordSource of the main Report,
but not in a Control, will not work.)

Larry Linson
Microsoft Access MVP