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

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


"mate" <matt@artcraftpromos.com> wrote in message
news:0edc01c351f2$51974730$a301280a@phx.gbl...

> 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