I have a SQL statement that updates a field when a form is opened, then I edit the details on the form and click save to save the new details as a new record, (therefore keeping a log of old records), but if I decide I don&#039;t want to save , I click a button and it undo&#039;s the changes, but how can I undo the changes and then save that record and move to a new page all in one go ?<BR>