Cancel printing of specific pages???

T

TerryC

Dear All,

Access 2002 SR3
Win2k

I have a situation which I have not encountered before and I can not find a
posting that helps me much.

I need to stop page(s) printing within the report.
eg.
Page 1 print
Page 2 print
Page 3 skip
page 4 skip
page 5 print
page 6 print
etc

The reason for this lies in a letter enclosing machine we use. It wants all
the first sheets of paper for each record in one pile and the second sheet of
paper in another pile. I have found some code on an mvps site that numbers
each page within the grouping 1 of 4, 2 of 4, 3 of 4, 4 of 4 and then back to
page 1 for the next record in the group. This works well.

As it is duplex printed I would like to suppress printing all occurances of
"3 of 4" and "4 of 4" in one pass and the others in another pass. I am not
sure what event (if any) will enable me to cancel a page printing.

Any suggestions or pointers would be really appreciated.

Terry

Note: The report has 3 variable length subreports and I am loath to try and
calculate the page transitions in seperate reports.
 
Top