Printing Question

[Golfinray]

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!!!!

 

[bhicks11 via AccessMonster.com]

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

 

[Allen Browne]

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.