Command Button problem

[DavidRobertArchibald]

I've set up a database that allows our customer service desk to enter orders. An order consists of two tables the header, and the products (linked by a one to many relationship). In the header and the products section is a flag field that I switch from "GBL" to "Pending" when the order is printed. This is done via a macro that also moves the data to a different (but identical) database called pending. My problem arrives when someone wants to edit the order and re-print it. I cant find a way to make my macro reset the flags to "GBL". I need to find a way to switch the field in the tables based on the Active Record. Any help?

 

[DavidRobertArchibald]

I could also solve my problem it I could use an update query to overwrite data. Is it possible to do so?