Save record to a different table before update VBA!

[dtaylor89]

I have a form that you can enter data to that saves to a table.
After the record is saved, if someone decides to update/edit that entry than the record before editing should be saved to a different table so that I can have a table of all records before they are updated.

Any suggestions!

Thanks, in advance

 

[mdlueck]

So how familiar are you with writing VBA code in Access?

For example, are you using VBA to populate unbound record edit forms, or are you using simple bound forms without VBA handling shuffling the fields between the table and the form controls?

If you have implemented unbound forms and VBA code to perform the SQL UPDATE, then prior to doing the UPDATE, SELECT out the record from the main table and INSERT it into an archive table, adding a DATESTAMP column and popuilate to that column the current DATE / TIME. Then you may proceed with the UPDATE to the main table. This will facilitate a change log of all changes to records.

Nothing more than a shell game with database records.

 

[dtaylor89]

I'm just getting familliar with VBA, so I'm not 100% sure on how to code the statement, I've been working on it for some time and haveen't coded it rite yet.

 

[mdlueck]

Is your Edit form a bound form to the table?

 

[dtaylor89]

Yes it is bound to a table