I want to track changes from "tbl1BusForDriver" in "tblAuditTrail". For that everything is working perfect for me except one thing. And the thing is it is giving me a value of the fields "Driver_ID" and "Bus_ID" in "FieldName" in tblAuditTrail..
I want it to show me which field was changed rather than giving me a value.. Please see the attached screenshot of my macro..

As I mentioned on the blog. The value for the Fieldname SetField, should be a text string of the field name. i.e. "Driver_ID", not a reference to the contents of the field.

PS. you need to scroll down in the Advanced form to see Attachments.