Here is what I want to do, though I am not sure it is possible.
I have a table with 4 fields:
ID Number (Auto Number Field)
Printed (Yes/No Check Box)
Date Printed (Date Field)
Printed by (Short Text Field)
The person would open up a form, select their name from a drop down (for the Printed By field) and then click a print button. The print button would ask how many labels to print and then generate that number of records in the table, it would also print a report based on those records, and lastly it would mark those records as printed and the date they were printed.
I think the printing part would be easy because all I would have to do is have it print any records not marked as printed (single user).
I guess my question is how to create a button that could generate the records (if this is even possible) and then do the printing all at once.