Audit Trail- MS KB ArticleQ183792

[qwkslvr1999]

I tried to use the code in MS's Article :How to Create an audit Trail of Record Changes in a Form. It does not seem to work in subforms. What should I do?

 

[David R]

In the subform's Before Update, refer to the main form's fields that you want to update. Use the Expression Builder or look up examples on referring to a main form from a subform.

HTH,
David R

 

[qwkslvr1999]

Thanks! I'll try that.