Make a form field uneditable?

K

Keith

I have a form where I would like to limit editing on one of its fields. The
field is a checkbox, and I would like the user to check (or not) check this
control when a new record is added. Once the record is added and saved, I
would like to prevent a user from changing the value (editing) in the field.
I can't use the locked property, because that won't allow me to enter data in
the field in the first place. Is there any way to accomplish this?

Thanks,

Keith
 
D

Dennis

in the on current event of the form put the following code

if Me.NewRecord = True then
TheField.Locked = False
else
TheField.Locked = True
end if
 
Top