First print of record original all others duplicate

[saudkazia]

Sometimes we need to ensure only one original invoice is printed. Rest of the times an invoice must display that it's a duplicate...
Using Northwind invoice as example...how can this be achieved...

[June7]

Don't understand what you want. What condition determines when there should be one and when there should be duplicate?

Is this related to your other thread https://www.accessforums.net/reports...eet-55659.html

[JamesDeckert]

Sounds like you'll need to have a field (boolean) in the invoice table to show if the invoice has been printed.

[saudkazia]

James. That's correct. But is there a way to determine whether a Report has been printed (not previewed but actually Printed)

[saudkazia]

June. I'll break it down for you.
I create and print an invoice. First print will determine that it's an original and a label will be printed that it's original.
Once I have printed the label will change to Duplicate to know that this is the second or more print and not the original

[June7]

As James said, need a field (Yes/No will do) to flag that the record has been printed to invoice. Then this field can be used as criteria for what value displays in 'label' - use a textbox with an expression.

The real trick is figuring out what event to put the code in that updates the field value. Could be in button Click event that sends document to print.

[JamesDeckert]

>>But is there a way to determine whether a Report has been printed (not previewed but actually Printed)
I don't know about this but you could in your form have a button to print the report (bypassing print preview), then you'd know it has been printed.

[saudkazia]

i like that idea. case resolved

[JamesDeckert]

You might want to prompt the user after the print to confirm the printout and at that point record it as printed.
At least make sure there is error handling so that if the print gets an error, you don't record it as printed.