Reprints

[renenger]

I have a question. I have a database that is used to input and print tickets. We would like to allow the ticket to print once and every time after that add the word "REPRINT" to the ticket when it is printed again.

I'm not sure how to do this. Any ideas???

Thanks
Brandy

 

[casey]

You could add a yes/no field (named [Printed], Default Value set to no) to each ticket record in your table. If you use a button on a form to print these(if not, use the wizard to create one), you can print the ticket and following the print code add...
Me.[Printed] = Yes.
It will be set to yes from now on.

Add a textbox to your form or report. Add the following to the textboxes' controlsource...
=IIF([Printed]=Yes, "REPRINT","")
The textbox looks at the [Printed] field, and if it equals Yes it will display PRINTED. If it equals No, then it's left blank.

HTH