Define number of pages to print

[Jeff]

Hi All!

I have a report that increases the date by one month for each page... a
payment book for monthly payments.

The problem is that the clients have various number of payments. One
customer will pay every month for 6 months and another every month for 4
months etc.

I want to be able to define how many pages to print, based on a
parameter the user will input when the report opens.

Any ideas greatly appreciated!

Jeff

 

[fredg]

Hi All!

I have a report that increases the date by one month for each page... a
payment book for monthly payments.

The problem is that the clients have various number of payments. One
customer will pay every month for 6 months and another every month for 4
months etc.

I want to be able to define how many pages to print, based on a
parameter the user will input when the report opens.

Any ideas greatly appreciated!

Jeff

Input where?
On the form used to open the report?

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.PrintOut acPages ,1,Me![ControlName]

Look up the PrintOut method in VBA help.

 

[Jeff]

Thanks for the assistance; that did the trick!