When validating() a Access database for changes need to log changes

[fachagooch]

I am working on a project that my manager wantes me to log the chages that are being made to a peticular database. The database is 4 columns of data with about 60 rows of data within. If i make a change to a piece of information in COL X of Row Y how would i record the information in COL 2 of Row Y?

all help would be appriciated!!!

[sashi]

Step1
Capturing the information of [X,Y] before modification

Step2
Capture the information of [X,Y] after modification

Step3
Log the before & after modification result

[semomaniz]

Please post your code and show us what you have done and the error you are getting