Jerry
I've used that approach too, but I have 'long-winded' customers who start a
new record and walk away. By waiting 'til they 'close' the new record, I
get a more accurate date/time value...
But maybe you've been blessed by 'prompt' customers!g
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Jerry Whittle" wrote in message
...
The date for a new record is easy. Make the default value of a date field
in
the table either Date() - which is just the date - OR Now() which is the
date
and time.
Who did it is a little more complicated. Below is a link to a function
that
will pull it. However you will need to run this function in a form on
something like the Before Insert event. If someone enters data directly
into
the table, it will not work.
http://mvps.org/access/api/api0008.htm
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"ko779" wrote:
I'm trying to catch the date in my Access db of when a new record is
created,
would like to capture the name as well.
How do you do it??