Permanently locking date field

[DocCon]

I have a table that has two date entry fields.

DateCreated [ Default Value =Date() ]

DateUpdated [ free data entry ]

I need to lock the DateCreated field as a permanent record which cannot be altered.

Can anyone suggest a possible solution please?

 

[pr2-eugin]

Go to properties window of the Text Box and then Change the properties like Locked = Yes and Enabled = No. You should have a field that is locked and disabled for edits.

 

[DocCon]

Thanks Paul I did try what you suggested and it does lock the field however that prevents me entering the initial date entry.

What I need is to enter the date when a new record is created then have the field locked after I move to the next field. Still not sure of what I have to do.

Regards
Connor

 

[pr2-eugin]

Okay then you could use the Form Current method..

Private Sub Form_Current()
    Me.dateCreated.Enabled = Not Me.NewRecord
End Sub