Re: Print off multiple reports based on combo box selection

On Mon, 30 May 2005 08:13:05 -0700, jademaddy
<jademaddy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>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 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]
.