print multiple copies of Rpt1 & 1 copy Rpt2 w/ single pushbutton?

[Guest]

For cattle auction settlement. I need to print 3 documents for each buyer
when they settle their bills. I need 2 invoices (office & customer copies)
and animal load out document.

Since the buyers settle in a random order. I created reports that have
buyer no as parameter. I have buttons on the sale entry form which
"previews" each of the required documents. Is there a way that the button I
push would automatically print all three documents in order without the
preview for each specific buyer? The invoices are letter sized and the load
out document is index card sized. The invoices use top tray of printer and
load out uses bottom tray.

Also, is there a way for me, at sale end print only the reports for buyers
who have not yet settled? The majority of buyers rush the office at the end
of sale. I don't want to print all invoices because quite a few settle
before the end of sale.

 

[Ricky Hicks [MVP]]

Create a dummy table with one text field in the table.
Add 3 records in this table.
Include this dummy table in the query for the report with no relational
joins ..

Your report will now print 3 copies ....

 

[Guest]

Thank you for your reply, however this does not work when the reports are not
the same. Rpt 1 prints the 2 copies (customer and office on letter sized
paper [8.5x11]), rpt 2 is a totally different report with different
information on it, printing on an index card [4x6] from a different printer
tray.

In addition, I used the wizard to put the buttons on the form and can not
get them to print directly. I have to set the wizard to preview the form in
order to enter the parameters.