By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,472 Members | 2,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,472 IT Pros & Developers. It's quick & easy.

Merging different reports (with parameters) into one

P: 1
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
Feb 12 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
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
Feb 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.