View Full Version : Audit Trail- MS KB ArticleQ183792


qwkslvr1999
01-29-2002, 07:36 AM
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
01-30-2002, 07:48 AM
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
01-30-2002, 09:33 PM
Thanks! I'll try that.