Time Stamp on a record

[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

 

[Fredg]

Try setting the Before Update event of the sub form:

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