I cross posted this as a VBA thread but since it's overlapping with what may be a form feature, I thought better about not posting it here as well.
clicking will take you to MS'
freebie function which can be pasted into my application, and if the instructions are followed serve to record changes made to a form by a user.
So far so good, until I try to utilize the code in each of two linked (master and sub) forms.
To spell out the details a bit....
The instructions call for adding a memo field called Updates in the table underlying ones form, adding that field onto your form, and tagging the AuditTrail() function name onto the BeforeUpdates property field of the form.
The difficulty I'm encountering occurs when I have a linked (parent/child) master/sub-form pair on which I have applied the above modifications. What I find is that the Updates field on the master is modified whether I modify the master or the sub-form?
Being a VBA 'newbie' this seems puzzling to me.
Anyone care to speculate on the dynamics of this?
clicking will take you to MS'
freebie function which can be pasted into my application, and if the instructions are followed serve to record changes made to a form by a user.
So far so good, until I try to utilize the code in each of two linked (master and sub) forms.
To spell out the details a bit....
The instructions call for adding a memo field called Updates in the table underlying ones form, adding that field onto your form, and tagging the AuditTrail() function name onto the BeforeUpdates property field of the form.
The difficulty I'm encountering occurs when I have a linked (parent/child) master/sub-form pair on which I have applied the above modifications. What I find is that the Updates field on the master is modified whether I modify the master or the sub-form?
Being a VBA 'newbie' this seems puzzling to me.
Anyone care to speculate on the dynamics of this?