Printing Question

This may seem like a bass-ackward thing to do, but I would like to put a
command button or combo on a form that enters criteria in a query that sets
what is to be printed in a report and then prints it. I have 4 managers, each
with their own data in tables. The query brings all four areas together and
is the source of the form. I have a report that prints all areas at once but
it is 29 pages. I would like to allow each manager to print only their area
without having to build four more reports and put four more command buttons
on the form. Thanks so much!!!!

Not unusual at all. As long as all you have to do is select the criteria to
filter the report by. Just set the Filter to the text or combobox on the
form. Here's an example:

OrderNo=Forms!OrdersFrm.OrderNo

Easy, peasy, lemon squeezy! But I have a feeling it's more complicated than
this?

Bonnie
http://www.dataplus-svc.com

Golfinray wrote:
This may seem like a bass-ackward thing to do, but I would like to put a
command button or combo on a form that enters criteria in a query that sets
what is to be printed in a report and then prints it. I have 4 managers, each
with their own data in tables. The query brings all four areas together and
is the source of the form. I have a report that prints all areas at once but
it is 29 pages. I would like to allow each manager to print only their area
without having to build four more reports and put four more command buttons
on the form. Thanks so much!!!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200806/1

Your idea is a good, flexible interface that makes it easy for the user to
enter any combination of critiera. That's much better than designing dozens
of individual reports.

Once the user has entered their criteria, they click a button that fires off
the report. In the Click event of the button, you build a WhereCondition
string to apply to OpenReport, so the report is filtered the way they want.

Here's a simple example that just filters by date:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
The second method shows how to build and use the filter string.

Here's a more comprehensive example:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
Download the example, and spend some time seeing how to build the filter
string. The example applies the filter string to the form itself, but it's
exactly the same to apply the filter to a report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Golfinray" wrote in message
...
This may seem like a bass-ackward thing to do, but I would like to put a
command button or combo on a form that enters criteria in a query that
sets
what is to be printed in a report and then prints it. I have 4 managers,
each
with their own data in tables. The query brings all four areas together
and
is the source of the form. I have a report that prints all areas at once
but
it is 29 pages. I would like to allow each manager to print only their
area
without having to build four more reports and put four more command
buttons
on the form. Thanks so much!!!!