Automatic date that doesn't change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top