Using a Current Date-Stamp

  • Thread starter Thread starter Chip
  • Start date Start date
C

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!!!!
 
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
 
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
 
Back
Top