View Single Post
  #2  
Old December 28th, 2009, 01:01 PM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default How do I save the date a record was last modified in Access 2003

Use the BeforeUpdate event of the *form* where the records are edited, e.g.:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[WhateverYourFieldIsCalled] = Now()
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Anne" wrote in message
...
How do I save the date a record was last modified in Access 2003?

I know a little about Access databases, and need help with a database I
designed. Any comment will be appreciated.

Anne