how to append the current record in a form to its source table before updating it?

[JonHuff]

I have a form in which users can create new records or modify existing records. All records are stored in one table. I want to be able to keep track of all changes made to existing records as well as allow htem to enter new records. They can enter new records fine. I need to append the current record in the form before anything about that current record is changed. How do I do this? Right now all that happens is the record is updated - I have no record of the old record.

the form has the following fields - these are the same names as the source table fields:

loannumber, exception, exception issue, investor, assigned to, comment investor, follow up date, due date, status code

note: there can be multiple instances of the same loannumber and investors. investors may have varying exceptions, exception issues, comments, follow up dates, due dates, and status codes for the same loannumber. i will try to attach a few example records from the table

[gnawoncents]

There are a number of ways to do this. One would be to open the record with all fields set to "Locked." Add a button that says something like "Modify this Record." When the user clicks the button, you can have it append the current record and unlock the fields. Make sure to set the appended record as the current record and the user would then be modifying the appended record.