invoice report - original + copies

[eyalco]

I've created an invoice form which generates a report.
I've also created a form in which the user defines how many copies he wants to print with the original (with a loop to the number of copies etc).
I need to join this form to the print button in the invoice so after the user states he's willing to save, this form pops up and the user states the copies number he's interested in.
How do I do it please?
The end result I'm aimint at is the caption to change once "original" and then "/
copy".
Thanks.

[MMcCarthy]

I've created an invoice form which generates a report.
I've also created a form in which the user defines how many copies he wants to print with the original (with a loop to the number of copies etc).
I need to join this form to the print button in the invoice so after the user states he's willing to save, this form pops up and the user states the copies number he's interested in.
How do I do it please?
The end result I'm aimint at is the caption to change once "original" and then "/
copy".
Thanks.

Just have the code to open the other form on the Print button on the Invoice form. Have all the Print code on a command button on the other form.

[nico5038]

Trouble with triggering a report is the fact that the printer can jam...

Personally I've used a form print as an invoice order (no report), allowing me after the first buttonpress to show a messagebox is presented asking the print was OK. When that's the case the DatePrinted is filled.
All other copies will show "Copy" when that date is filled and only a special button will allow a new "Original".

Nic;o)

[eyalco]

Thanks guys.
The report works well - it needs the addition of the "copy" caption.
The thing is that the form I'm trying to connect is using 3 queries : del, add 0 + add 1 so when user writes how many copies, the 1's are the copy caption.

When I passed the printing procedure, the form didn't recognize this -
"strCriteria = "[invoice_no]= " & Me![INVOICE_NO]"
so I have to debug it all the time.
Can you assist please?

[MMcCarthy]

You need to change your link criteria to ...

strCriteria = "[invoice_no]= " & Forms![MainFormName]![INVOICE_NO]

where MainFormName is the name of the Invoice form which must remain open in the background during this operation.

[eyalco]

Thanks' it works.

Hope it's ok for me to continue here as the report itself is only in copy header.
I'm using this code :

If Forms![FRM_COPIES]![COPY] = 0 Then (defines qry add 0)
Me.ORG_OR_COPY = "original"
Else
Me.ORG_OR_COPY = "copy" (for every copy the user states)
End If
End Sub

Appreciate any help here.