Merging different reports (with parameters) into one

[Marmarmar]

Hello, I need some help on this.

I have developed an Access Form to make different report according to time period, selections, groups, user, ID and states. Now I need to create a general report that is composed of different selections. Each report has a VBA function at load time that creates complex query and set the RecordSource.

I tried to used subreports inside one general report, but cannot find a place to put the parameters. I cannot use public or global functions since they should change for each sub report.

Any hint?

Thank you

[puppydogbuddy]

Hello, I need some help on this.

I have developed an Access Form to make different report according to time period, selections, groups, user, ID and states. Now I need to create a general report that is composed of different selections. Each report has a VBA function at load time that creates complex query and set the RecordSource.

I tried to used subreports inside one general report, but cannot find a place to put the parameters. I cannot use public or global functions since they should change for each sub report.

Any hint?

Thank you

The query is the record source for your report, so reference the controls on your parameter form in the criteria row of the applicable columns of your query.....Forms!YourForm!YourControl