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

[Guest]

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?

 

[Rick Brandt]

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?

Me.ControlName.Locked = Me.CheckBoxName

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

 

[Guest]

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?

 

[missinglinq via AccessMonster.com]

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