Printing labels

B

Bob B

After entering data on form I would like to selectively print a file label
if it is a new client but if it is a repeat. How can I do this.
 
L

Larry Daugherty

I would create a new Boolean field in the client record named
LabelPrinted. After you create that field you might use an update
query to set that flag to True in all records where the label has been
printed.

Set the query for the label print run to return only those records
where LabelPrinted is false. At the conclusion of an error free print
run, run an update query to set LabelPrinted to True.

Another way is to have an entry date field in the record and base the
query for the print run on a date after the last label print run.

HTH
 
Top