Updating checkboxes after running a report

[JDSSerrum]

Please help!,

I am trying to update a checkbox - called 'invoiced' after a report (Used to
generate an Invoice) has run.

I have tried putting the macro on both 'on close' and 'on open' but it fails
all the time, (I presume becasue it is happening to early or late). The
macro expression is correct I have tested it on a form with a button.

Essentialy I would like it to autmatically mark customer support logs as
invoiced once the report has run. The invoice report is built from a query
and contains many 'support logs' thus the macro needs to change the value of
all the 'support logs' on the report.

Am I going about this in the wrong manner, where should I place the macro
event. Any help would be great! thanks for your time

 

[lupins46]

Assuming that the relevant data is not continually changing then use the report recordsource as the basis of an update query to update the relevant records, once the report is printed to your satisfaction.
If you make it automatic you risk the report not completing due to a printer wreck or any other reason, and updating erroneously.
But of course it's your app.

 

[JDSSerrum]

Thanks for your help, but am a bit confused? A detaild account of what I am trying to achieve:

A report is generated from a query only showing 'support' not invoiced.
This becomes the invoice for the customer.
Instead of manualy changing all the 'Invoiced' checkbox's in the 'support' table.
Can a macro do this automatically once the 'Invoice' Report has been run - (The report is outputed to acrobat writer)

Thanks and please excuse the ignorance?

 

[lupins46]

If the report is based on a query such as:
Select * from mytable where Invoiced = false

Then you want to create an update query which is:
Update mytable set Invoiced = true Where Invoiced = false

You could run this query from the Close event of the report, provided there are no circumstances EVER that you would not want it to run. Alternatively run the query from a button placed alongside the one which runs the report.