Disable or lock a control based on the value of another control

M

Mark Baker

Basically I want to lock any further input to a control once a tick box has
been checked. I know it can be done but i really need an example to work off
and can't find one.

can anyone help?
 
R

Rick Brandt

Mark said:
Basically I want to lock any further input to a control once a tick
box has been checked. I know it can be done but i really need an
example to work off and can't find one.

can anyone help?
Click to expand...

Me.ControlName.Locked = Me.CheckBoxName

You will likely need that in both the AfterUpdate of the CheckBox and the
Current event of the form.
 
M

Mark Baker

Sorry, I think i need further help!
I understand when you say put code in the afterupdate of the check box, but
where exactly should i put the code in the 'currenevent' of the form?
 
M

missinglinq via AccessMonster.com

Private Sub Form_Current()
Me.ControlName.Locked = Me.CheckBoxName
End Sub
 
Top