Time Stamp on a record

  • Thread starter Thread starter mate
  • Start date Start date
M

mate

I have a subform within a form. When a user creates a new
record in the subform, I would like to have the date/time
automatically stamped on that record at the time of
creation. I've tried doing this, but whenever i access
that record at a later time, it shows up with the current
time instead of when it was created. Any help would be
great! thanks. mate
 
Try setting the Before Update event of the sub form:

If IsNull([DateField]) then
[DateField] = Now
End If
 
Back
Top