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