URGENT!! Run an update query after printing reports

[williamwatterson]

How would you go about running or resetting an update query after each group break. This is for an invoicing system where the invoice number is updated by one every time new customer details are recognised when batch rinting outstanding invoices.

HELP!

 

[DoubleD]

I would suggest having the Invoice number on the record from the start. But set something up to update a CheckBox when an Invoice is printed.

Either way, here is how you could go about it.
You must have a form where the user defines which invoices they want to print.
Code behind a command button tells the database to print certain invoices. Before you call the print command, assign the invoice numbers by cycling through a filtered recordset. Use the filter the user has defined as your filter to define the recordset.

I am what I am based on the decisions I have made.

DoubleD