how to prevent subsequent system date from being update

[racerrunner]

I've design a form as such when i FIRST add a NEW
RECORD, I want the system date to be capture into the
form. I have a table calls Register. And this table
has a field "DATE" which takes the value of the system
date(=now). However, when i open the same record the
next time, the orginal value(at the time when the
record is created) of the field "DATE" will be
replaced by the new system date. However, i do not
want this to be happen because i want the field "DATE"
to take the value of the system date when i first
created the record. My question is how to prevent
subsequent system date from being updated in the
record whenever i open the same record? Thank you.

 

[pono1]

Remove the default value assigned at the table and then put code similar to the following in the form's Current event.

If Me.NewRecord = True Then
   YourTextBoxforDate.Value = Now
End If

Regards,
Tim