Ask Me Help Desk - Access Macro putting a value rather than a field name

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)

- Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)

- - Access Macro putting a value rather than a field name (https://www.askmehelpdesk.com/showthread.php?t=822054)

Access Macro putting a value rather than a field name

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.

All times are GMT -7. The time now is 05:09 AM.