Tracking user changes - Part 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top