Update query then record changed fields in new table
I have an 2 tables that I am comparing and an update query and it works well when I use it to update changes from my tblUpdate to tblMaster I've even manage to have the records that have been updated marked with "U" in a field called Flag.
But what I would really like to have is a 3rd table to log the history and by history all I want is the ID field for the record plus the field(s) that were changed and what they were changed from/to.. I do not need to know by who, what computer, time, date or any of that. (At the moment I know what record was changed but not what field(s)...)
I have seen this done using forms and subforms in an Employees/Salary scenario it looked great but I have no need for forms.
Just some way to record in a 3rd Table exactly what has changed...
Or if there was some way to highlight the changes in one of my tables emboldened/coloured or whatever showing just which field(s) had changed in each of the updated records that would suffice...