Report Parameters and updating a Table

[Guest]

I have a form called ticketbook. I have a command button on this form that I
would essentially like to print a report and update a two fields in my table
at the same time. The report is based on a query which has three
parameters. They are called sent date, issue date, and dt forwarded. The
query will pull all of the tickets that were issued on a certain date.
However, the sent date and dt forwarded will be displayed on the report. I
would like for the dt forwarded an the sent date to automatically be added to
the records that were query. Is this possible? If so, how? Thanks.

 

[Allen Browne]

There's a bit more to it than that. Over time, a record could get printed
multiple times, so you need to store which records were printed in which
batch, and what the parameters were for each batch.

See:
Has the record been printed?
at:
http://allenbrowne.com/ser-72.html
The article includes a sample database you can download. It tracks the
batches and when they were printed. You can use that example to add the
other parameters to the batch table (i.e. the date sent, issue date, and dt
forwarded.)