Need date to automatically update when record is modified.

[Stacey]

Honestly I can't believe I'm asking this question, since
I've worked on Access for years, but I've been away from
it for a bit and for some reason I'm feeling rusty.
I need to create a date field that automatically updates
with the current date and time each time a record is
modified/updated. Do any of you know how to do that?
Thanks

 

[Tim Ferguson]

I need to create a date field that automatically updates
with the current date and time each time a record is
modified/updated.

Can't do it in Jet.

You can create a record datecreated stamp using the DefaultValue.

You can use the BeforeUpdate event of the form to stamp updates, but it
won't catch updates using vba, sql, excel etc etc.

You can use MSDE, which does have a proper timestamp field as well as
programmable triggers, but is a major migration from Jet.

Hope that helps


Tim F