I have an update query that updates the records of one table by the contents of another for 6 specific fields.
Each time a record is updated via this update query I would like a message box to appearthat shows the old value and the new value for the 6 fields that gives the user the option to accept the change or flag the change for further review.
I figure I have to use a loop or two but am not sure how to accomplish this.
Any thoughts? Suggestions?