Using a Current Date-Stamp

[Chip]

I am very new to ACCESS and VB for that matter but I am trying to create a
field in a ACCESS Form that merely updates to the current date and time that
the record was created or modified but I cannot seem to get anything to
work. Is there a way to do this in ACCESS? Thanks in advance!!!!

 

[Rob]

yes, by adding the below, as soon as the form is changed,
the control date will update.

Private Sub Form_AfterUpdate()
txtUpdateTimeStamp = now()
End Sub

 

[Steve Schapel]

Chip,

Assuming the field is in the table/query that the form is based on,
and represented by a control on the form, in the BeforeUpdate event of
the form, put the equivalent of...
Me!NameOfField = Now

- Steve Schapel, Microsoft Access MVP