Make a form field uneditable?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top