Last Update Date on Record

  • Thread starter Thread starter Larry
  • Start date Start date
L

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