Update Time Stamp

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)



Scott2617 said:
I have a time stamp field in my tables. I want to automatically update
Click to expand...
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.
 
Back
Top