Tracking record changes and logging into a new table

[Moonman]

I am have a shared form that allows several users to make changes to information in drop-down menus and memo fields. I need to identify all changes made on a weekly basis, and would like to have only the identified changes populate a table. I would like to have this vba code initiated via a button, that also resets the data date in preparation for the upcoming week. Since I am relatively new to the vba world, I would like some spelled out sample code that is based on the following information:

Table1: WorkWeek
Table2: WWChanges

Field1: EngStatus (Memo)
Field2: PlanStatus (Memo)
Field3: WDS (ComboBox)
Field4: DWG (ComboBox)

Any help in this matter would be greatly appreciated!!!!

Thank you

[June7]

That is an audit log (or audit trail). Frequent topic in form. A search should return quite a few threads.

Here is one version for audit log: http://allenbrowne.com/AppAudit.html