Update Query

[pixiedust]

Hi, I have a Select query I use to generate a report. Query is simple enough, it checks to see if the field Invoice_dispatched is false. So this works fine, and produces the report fine. However, whenever this query is run, I need it to then update the Invoice_dispatched field to true. So how would I go about linking this update query to the select query in order to do this?


Thanks

 

[CJ_London]

use some vba behind perhaps a button on the report or perhaps after you close the report to run the update query