Invoice printing - original and copy

[wilkob]

I have a made a little DB that collects data and prints it on an invoice.

I would like to print 1 original and 1 copy (or 2 copies if needed in the future)

Anyone have an idea how I can achieve this (the easiest possible way).
I have been thinking of subs-reports but it seems somewhat difficult

 

[Rickster57]

report

Don't know if this helps but if you are printing a report and I am guessing you first preview it you can try this in the On Click Event of your command button

DoCmd.OpenReport "[YourReport]", acViewPreview
'Print out 2report copies
DoCmd.PrintOut , , , , 2

 

[wilkob]

what I would like is to click the print button ones and then an original (which should appear on the document) and a copy (als to appear on the invoice) should come out

 

[Rickster57]

So you want the first copy to say on it "Original" and the second to say "Copy". ? Just waking up so bare with me..........

Create a duplicate of your report. The one report (call it original) put somewhere on the report "ORIGINAL". Copy and paste the Original report and call it OriginalCopy. Somewhere on the report place "COPY"

Behind the On Click Event of your command button that prints :

DoCmd.OpenReport "Original", acNormal
DoCmd.OpenReport "OriginalCopy", acNormal