Automatic Date

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000
I have a field that enters the date automatically - using
Date(). This date changes every day. But I want a
permanent date - a Date that does not change from the date
of entry. What date code do I use?

Aurora
 
Is your field bound to a table? Jsut put your "Date()" in the field's,
DEFAULT value.

Or, use code that writes the current date only when you add a record. Put
it in the form's BEFORE INSERT event.
 
Back
Top