how to protect field

G

Gerald

I have date field in a form, which can be entered only once

it should not allow any changes onto that field if done later e.g delted, or
reentered it

thanks
 
K

Keith W

Gerald said:
I have date field in a form, which can be entered only once

it should not allow any changes onto that field if done later e.g delted,
or
reentered it

thanks
Click to expand...

Put some code in the form's On Current event (untested):

If IsNull(Me.txtMyDate) Then
Me.txtMyDate.Locked = True
Else
Me.txtMyDate.Locked = False
End If

HTH - Keith.
www.keithwilby.com
 
Top