In the AfterUpdate event procedure of your subform:
With Me.Parent
.LastUpdated = Now()
.Dirty = False
End With
I'd suggest different name for this field, though: LastUpdated is
a property of DAO recordsets.
Quote:
> Are you expecting activity in the subform to update a value in the Main form
> or in the subform?
> You would need code in the subform Before Update event to update the field
> on the main form.
> Duane
> > I have a form containing one linked subform.
> > For the main form, I use a "before update" procedure to write the current
> > date "now()" into a field in the current table labeled "LastUpdated."
> > However, whenever I update info in the related subform, the LastUpdated
> > field does not get updated. How do I get that to work?
--
Perth, Western Australia
Tips for MS Access users at:
http://odyssey.apana.org.au/~abrowne
updating subform