Tracking user changes - Part 2

I posted this already, but think I lost it; my apologies if it shows up
twice. Rick's suggestions about tracking changes in my form worked
perfectly, except that changes to the subform don't trigger the update to the
timestamp field (coded as a beforeupdate event on the main form). What's the
best way to update a field in the main form based on a change to a field in a
subform? As always, TIA.

Use the AfterUpdate event of the subform to update the field in the main
form, and save the change:

Private Sub Form_AfterUpdate()
With Me.Parent
![NameOfYourDateTimeField] = Now()
.Dirty = False
End With
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Carol Giannini" wrote in message
...
I posted this already, but think I lost it; my apologies if it shows up
twice. Rick's suggestions about tracking changes in my form worked
perfectly, except that changes to the subform don't trigger the update to
the
timestamp field (coded as a beforeupdate event on the main form). What's
the
best way to update a field in the main form based on a change to a field
in a
subform? As always, TIA.