Monitor fields for changes

[thefourthwall]

I need to have the field "Last Modified Date" update anytime information changes in another field on the same form for customer data - cell number, address, etc.

From searching threads I found thread 1490098 in which the After Update event of fields to be "monitored" has
Me.Parent.txtLastUpdate=Now() code written. My field is called txtDateLastModified, so the field referenced would be that and not txtLastUpdate

At least that's how I understood it; not using a subform, so the "Me.Parent" does not apply, but is it correct that putting Me.txtDateLastModified = Now() code behind the After Update event of a field will cause the date modified field to update if other fields' values are changed?

 

[PHV]

I'd use the BeforeUpdate event procedure of the Form ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[thefourthwall]

Of the Form, and not individual fields, is that right?

 

[PHV]

Yes.

 

[thefourthwall]

Why is that, would you mind either explaining or pointing me to a resource that would indicate why? I just want to learn more about Access: the more I am able to do, the more I want to know - is that strange?