I am trying to lock out 7 fieldsin a subform by keying off a value of a textbox, I want the 7 fields lock or non editable. how can i do this?
I am trying to lock out 7 fieldsin a subform by keying off a value of a textbox, I want the 7 fields lock or non editable. how can i do this?
Set the Enabled and Locked properties of the textboxes.
i.e.
Me.MyTextbox.Enabled = False
Me.MyTextbox.Locked = True
However, be careful if other code sets the focus to these fields, if you do you'll get a runtime error.
Thanks I was just using locked= true.It works great thank you.