Print multiple invoices

G

Guest

I have an Invoice list on a form. When a invoice number is selected on the
form you print the report which is filtered on the invoice number selected on
the form. I do this so you can have page nubers for each clients invoice (If
you had a report from and to invoice number the page numbers would flow over
the diff clients and invoice numbers).
My problem is I want to have an option to print all invoices one after
another automaticaly. When I put a loop in a macro to do this with a stop
macro when it gets to the last record - it tels me a macro can only run
itself 20 times.

Any sugestions
 
J

Joseph Meehan

thecuzin said:
I have an Invoice list on a form. When a invoice number is selected
on the form you print the report which is filtered on the invoice
number selected on the form. I do this so you can have page nubers
for each clients invoice (If you had a report from and to invoice
number the page numbers would flow over the diff clients and invoice
numbers).
My problem is I want to have an option to print all invoices one after
another automaticaly. When I put a loop in a macro to do this with a
stop macro when it gets to the last record - it tels me a macro can
only run itself 20 times.

Any sugestions

Put the page number in the group footer of your report and it will reset
for each group (Each Client).

Good Luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top