Home All Groups Group Topic Archive Search About
Author
9 Jul 2009 1:45 AM
BrowDa
I am trying to create a field in which the date time will change when I edit
any field in the form.  I can't figure out how to do it even though it is
probably quite easy.  Can anyone help me?


Thanks in advance for any help.
--
DLB

Author
9 Jul 2009 3:45 AM
John W. Vinson
On Wed, 8 Jul 2009 18:45:01 -0700, BrowDa <Bro***@discussions.microsoft.com>
wrote:

>I am trying to create a field in which the date time will change when I edit
>any field in the form.  I can't figure out how to do it even though it is
>probably quite easy.  Can anyone help me?
>
>
>Thanks in advance for any help.

Put code in the Form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel as Integer)
<do any form validation first>
Me!txtWhenUpdated = Now
End Sub

--

             John W. Vinson [MVP]

Bookmark and Share

Post Thread options