Update Time Stamp

[Guest]

I have a time stamp field in my tables. I want to automatically update this field each time a record is inserted or updated - similar to a trigger in SQL Server. Is there any easy way to do this without writing VBA code - can I use an expression on the Before_Update event, etc

Any help would be appreciated.

 

[Douglas J. Steele]

It's just a single line of VBA code that's required:

Me!MyDateField = Now()

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I have a time stamp field in my tables. I want to automatically update

this field each time a record is inserted or updated - similar to a trigger
in SQL Server. Is there any easy way to do this without writing VBA code -
can I use an expression on the Before_Update event, etc.