Print off multiple reports based on combo box selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built my first database which I use at work to provide numerous
different reports giving stockloss details for 350 of my shops. I have about
36 reports that I am able to run off giving details at individual store or
district level. Each one of these reports has a parameter query as its
source, which normally asks me to enter the year and month for the data I
want.

Each month I have to print a pack that contains about 25 of these reports. I
have created a macro that does this but I have to enter the same year and
month every time each report is going to be printed.

Can someone point me in the right direction to negate the need to enter the
same information every time these reports are printed. Ideally I would Like
to produce a form that has a couple of combo boxes on it.

1) For the Year
2) For the Month

The user could select the chosen combination click a button and the reports
would print off.

Thanks
 
Each month I have to print a pack that contains about 25 of these reports. I
have created a macro that does this but I have to enter the same year and
month every time each report is going to be printed.

Can someone point me in the right direction to negate the need to enter the
same information every time these reports are printed. Ideally I would Like
to produce a form that has a couple of combo boxes on it.

1) For the Year
2) For the Month
Click to expand...

The simplest way would be to use a Form reference as your criterion.
Rather than a criterion such as [Enter year:], create a small unbound
form named frmCrit. Put textboxes - or, better, combo boxes with valid
years, months, and (if desired) other criteria - on the Form, and use

=[Forms]![frmCrit]![cboYear]

(for example, assuming you named the year combo cboYear) as a
criterion.

All of the reports will use the form for their criteria.

If the reports differ only in the query criteria, you could make it
all one multipage report using the report's Sorting and Grouping
feature, but running multiple reports is probably just about as easy.

John W. Vinson[MVP]
 
Back
Top