Last Update Date on Record

[Larry]

Hi,
I think I need a macro for this.
I want to update a last update date field in my main
customer table anytime the customer table or any other
support table (payments,order,etc) data is updated.
I'm not sure which Event it should be attached to?
Thanks, Larry

 

[Steve Schapel]

Larry,

It seems to me that the AfterUpdate event of all relevant data forms
would be the place to put the macro. Probably you need an Update Query
which will set your LastUpdated field to Date() for the current customer
record on the form, and then use an OpenQuery action in the macro to
make this happen.