In today's lesson I'm going to show you how to backup a record in your database before someone makes changes to it. This way you have a complete history of all of the edits, in addition to a date/time stamp of when it was edited.
Making a Backup Table
Change AutoNumber to Long Int
Append Query Warning Messages
Confirm Action Queries
You may want to read these articles from the 599CD News: