Update field to NOW() after data added or changed

rick
rick used Ask the Experts™
on
In my ms access table, I have a "last updated" field, which i want updated to NOW() after any fields are added or updated.

I know it's an EVENT but not sure how to enable.  I'd prefer to use an EXPRESSION and not VBA.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014

Commented:
It is the AfterUpdate event

Author

Commented:
Thank you, but I'm looking for more specifics.  At what level is the update?  Form?  

and what would the expression look like?
Distinguished Expert 2017

Commented:
one approach you wish to stay away from, macros following an event.

How are you providing the user with access to make changes?
The form to make changes is how you would achieve this by setting the last updated to now, once the user commits their change and you verify..

Do you have an option to migrate to a database that provide trigger ...
SQL express ......


Yes, if your update is within a form, that is where you can include a change to a field to include the last updated..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial