Record Date Changed for a record when not using a form

[morg59jeep]

Is there any way to update a DateModified field in a table if a record is changed? I know this is possible when the data is changed in a form but what if someone changes the data directly on the table. Is there any way to record this?

 

[lespaul]

Table level events like that use 'triggers' which access doesn't support. If you're using SQL Server or Oracle then you can create triggers that act when a change occurs at the table level.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins