Automatic date that doesn't change

M

MEOlsen

How can I add a date field on a form that pops in today's date automatically,
but that then stays at that date? In other words, I want it to be the date
the record was added, but not to update each time the record is accessed by a
user.

Thanks!

MEOlsen
 
E

Ed Robichaud

To record the creation date, create a date/time field in your table and make
the default value Date() -for date only, or Now() for date and time. You
may want to create a second date/time to record updates. For that field,
add a code line to the AfterUpdate event of its bound form control like:
Me![myDate]=Date()
-Ed
 
Top