How can I programmatically change the print source so I
can alternate printing from one tray to another tray?

We have set up a report in MS Access that requires
alternating trays during a single report cycle. We have a
primary report that is assigned to print to tray 1, with a
subreport assigned to print to tray 2 due to the need to
print on a different type paper stock. We need the two
reports to collate properly in bin 1. The application
works perfectly when the reports are separated, but once
the second report is merged in as a subreport, it defaults
to the primary report settings and prints out of the same
tray 1.

I have searched the internet for any documentation on
this, but have not been successful in finding an answer. I
originally wrote the report in Crystal Reports, but
switched to an MS Access format as this feature is not
supported in version 8.5. If you know how this can be done
or have an example report that does this, can you please
advise or for supply an example.

"Jim Burkett" <(E-Mail Removed)> wrote in message
news:05f801c519b1$edcbf640$(E-Mail Removed)...
> How can I programmatically change the print source so I
> can alternate printing from one tray to another tray?
>
> We have set up a report in MS Access that requires
> alternating trays during a single report cycle. We have a
> primary report that is assigned to print to tray 1, with a
> subreport assigned to print to tray 2 due to the need to
> print on a different type paper stock. We need the two
> reports to collate properly in bin 1. The application
> works perfectly when the reports are separated, but once
> the second report is merged in as a subreport, it defaults
> to the primary report settings and prints out of the same
> tray 1.
>
> I have searched the internet for any documentation on
> this, but have not been successful in finding an answer. I
> originally wrote the report in Crystal Reports, but
> switched to an MS Access format as this feature is not
> supported in version 8.5. If you know how this can be done
> or have an example report that does this, can you please
> advise or for supply an example.
>

So, basically, you have one report (the fact that it has a sub-report is
irrelevant, it's all one report), but you want alternating pages printed
from different paper trays?

I have to say that I will eat my hat if that can be done in any reporting
tool!

I think you will need to separate your reports again, and modify each one so
that it only runs for one page at a time (I am assuming from your
description that one page is in some way equivalent to one record or group
in the report's recordsource). Then, you will need to write a loop in VBA
that prints the reports alternately for each page in turn.

Of course, this leaves open the possibility that some other user could
interpose some other document in the middle of your print run!