Undo last save

[RGFlade]

I have a form that list all people waiting and it has a button called
"Completed" when the staff member presses the button it changes the status
from x to y. However, I would like to put a button one the page to allow
them to roll back or unsave the last "completed". Can you tell me how to do
this? Thanks

 

[Rob Oldfield]

You just need to store the relevant PK each time the completed button is
hit - either in a global variable or in a table. When the user then hits
Undo you just need to run the SQL to put the value back to x.