Required to Print 2 Copies of Specific Report

[Aamer]

Is it possible If i print a report By default it prints 2 pages.
intead of me changing the # 0f Copies to 2
Please not this is required for specific report not all reports

 

[Tom van Stiphout]

On Thu, 12 Nov 2009 22:07:01 -0800, Aamer

You can simply repeat your DoCmd.OpenReport statement.

-Tom.
Microsoft Access MVP

 

[Gina Whipp]

Aamer,

I create a table named tblCopies with a field cCopies and place a 1 in the
first record and a 2 in the second record. Drop the table in the query that
is the RecordSource of the report. Now, if I want to change the amount of
copies, I have a table to make the changes. This allows the end-user to
control now manu copies they want. You can also use that table to put
*Customer Copy", *Store Copy* or any other message you want at the bottom by
simply typing that in the record and then placing that field in the Report
Footer.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm