G
Glen
Knowledge Base Article 1975592 has some code to create a
audit trail of any changes done to a form. I have
modified so it saves the changes to a table (instead of
on the form). I also track who made the change. Clients
love it.
Small problem--you put =AuditTrail() to call the function
in the Form's Before Update event property of the form
you want to track. However, it does not work if the form
is a subform. It seems that when something is changed on
a subform, the subform's Before Update event does not run-
-and the master form's Before Update event seems to ignor
that the subform is being updated. I do have =AuditTrail
() on both forms. Any suggestions?
audit trail of any changes done to a form. I have
modified so it saves the changes to a table (instead of
on the form). I also track who made the change. Clients
love it.
Small problem--you put =AuditTrail() to call the function
in the Form's Before Update event property of the form
you want to track. However, it does not work if the form
is a subform. It seems that when something is changed on
a subform, the subform's Before Update event does not run-
-and the master form's Before Update event seems to ignor
that the subform is being updated. I do have =AuditTrail
() on both forms. Any suggestions?