CODEWITHSUNDEEP
formsdatetimems-access
JT2013
JT2013

Reputation: 643

How to record Mod_Date_Time in MS ACCESS

I have many forms in my database for which I've been able to capture a CREATE_DATE_TIME for each record in each table. Is there a way to also capture the MOD_DATE_TIME for each record? I.e. capture when the last time was that the record was modified?

Upvotes: 0

Views: 42

Answers (1)

Gustav
Gustav

Reputation: 55906

Set the value of MOD_DATE_TIME in the BeforeUpdate event of the form - just like you already for CREATE_DATE_TIME in the BeforeInsert event.

Upvotes: 1

Related Questions