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

Parameter Report

P: 7
Hi

I have created a report which contains several charts/subreports which are based on parameter queries. Every time I open the report i have to enter the criteria in a prompt box several times (one for every chart/subreport.)

Is there a way of only entering the criteria once so all the charts/subreports display the information based on that criteria?

Thanks
Sep 3 '07 #1
Share this Question
Share on Google+
2 Replies


Jim Doherty
Expert 100+
P: 897
Hi

I have created a report which contains several charts/subreports which are based on parameter queries. Every time I open the report i have to enter the criteria in a prompt box several times (one for every chart/subreport.)

Is there a way of only entering the criteria once so all the charts/subreports display the information based on that criteria?

Thanks
Depending on what your parameters whether it be between date, numbers various things you need to be looking at what is termed QBF in Access parlance or Query By Form as it is known

This is where you have located somewhere, either on your main menu or as a floating popup screen something that that unbound text boxes or other controls on which you can rely to provide the necessary values for your queries servicing the reports.

The syntax goes into the criteria rows of the queries in the form as follows

=Forms!YourFormName!YourControlName

What happens here is that whatever you provide in those unbound fields (IF THE FORM IS OPEN) then the queries will reference those controls and use those values for the criteria. In short you can kick those parameter boxes into touch and never be asked again

Hope this helps if not there is plenty of stuff about QBF query by form methods on the net or someone else might expound some

Jim
Sep 4 '07 #2

P: 7
Depending on what your parameters whether it be between date, numbers various things you need to be looking at what is termed QBF in Access parlance or Query By Form as it is known

This is where you have located somewhere, either on your main menu or as a floating popup screen something that that unbound text boxes or other controls on which you can rely to provide the necessary values for your queries servicing the reports.

The syntax goes into the criteria rows of the queries in the form as follows

=Forms!YourFormName!YourControlName

What happens here is that whatever you provide in those unbound fields (IF THE FORM IS OPEN) then the queries will reference those controls and use those values for the criteria. In short you can kick those parameter boxes into touch and never be asked again

Hope this helps if not there is plenty of stuff about QBF query by form methods on the net or someone else might expound some

Jim
Thanks for the advise Jim, had a look at some QBF methods and have solved the problem.

Cheers
smowen
Sep 4 '07 #3

Post your reply

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