Two tables "tblEmploye e" and "tblEmployeeHis tory".
Each table has identical fields.
Each field on the form "frmEmploye e" detects a change (BeforeUpdate) and checks a corresponding box (hidden on the form).
frmEmployee then detects a change (BeforeUpdate) and...
1.) Updates a single ModifiedDate field on the form
2.) Appends the current record to the tblEmployeeHist ory...