Checkbox Problem

[sdkramer]

I'm using code to disable a field when a checkbox is checked.

Ex.

If chkBox=-1 Then
Item.Enabled=False
Else
Item.Enabled=True
End If

And I've had to put these in the OnCurrent Event of the form as well as the afterupdate on the checkbox. But. I'm using a tabular form, and it's disabling the whole column. Can I disable only that record's entry?

 

[David R]

Not with a continuous form I don't believe. Real pisser, isn't it?

On the other hand, if you Lock the field as well as Disable it, then "visually" the user will not know the entire column is locked.

[This message has been edited by David R (edited 04-25-2002).]

 

[bbeeching]

Try this

If (Eval("[Forms]![frmYourFormName]![YourCheckboxName] = No")) Then
OtherControlName.Enabled = False

ElseIf (Eval("[Forms]![frmYourFormName]![YourCheckboxName] = Yes")) Then
OtherControlName.Enabled = True
End If

Hope this helps!