[AccessD] Visual Basic Form - Check If Recordset/Field Needs Updating

To all,

Firstly my appologies for cross-posting this on the Access site, the reason for this is I haven't seen much (well very very little to be precise) activity on the VB Group.

I am after some advice really, basically I would like to know the best way to check if a recordset/field needs updating.  Say if a user has a client record in front of them and doesn't make any changes I need to detect this so I don't have to bother to update any recordsets/fields, but if the user does make a change to any textbox/checkbox/dropdown etc I would like to detect this so that :
    1. I can update the recordset/field
    2. So I can create a log of the record the user changed (plus if possible the name of the field and what they changed it from and to).
So any help on this will be appreciated, I have come up with a couple of solutions but the one seems long winded and the other, I just can't get to work quite right.

Thanks in advance for any help on this.

Paul Hartland