Update a field based on any changes in a that record

[skooterboy]

Hi All,

Still fairly new to Access events and triggers, and trying to get my head around it all.

I have a field called "date_modified" (I know, so original). I'd like to set up an event that will automatically update this field to the current date if any other field in the same record has been changed.

I'm hoping this is something simple. Any suggestions?

Thanks everyone.
Shane

 

[jdraw]

Can you tell us what you have found on Access triggers?

If your field is Date_Modified datatype Date, then in your processing logic,
if you Update that record, include

Date_Modified = Date