check box

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

Hello,

I want to check a box and have other fields disable. Do I do that in code
or is there a place in the form to do that?

Thanks - Joel
 
Joel,
Sure... use the AfterUpdate event of the checkbox...

Private Sub YourCheckBox_AfterUpdate()
If YourCheckBox = True then
YourField1.Enabled = True ' etc... etc... for any other
fields
Else
YourField1.Enabled = False
End If
End Sub
hth
Al Camp
 
Use the AfterUpdate event of the text box.

If the check box is bound to a field, and you want Access to remember that
the other fields are disabled whenever you visit that record, use the
Current event of the form as well.
 
Thank you.

AlCamp said:
Joel,
Sure... use the AfterUpdate event of the checkbox...

Private Sub YourCheckBox_AfterUpdate()
If YourCheckBox = True then
YourField1.Enabled = True ' etc... etc... for any other
fields
Else
YourField1.Enabled = False
End If
End Sub
hth
Al Camp
Click to expand...
 
Thank you.

Allen Browne said:
Use the AfterUpdate event of the text box.

If the check box is bound to a field, and you want Access to remember that
the other fields are disabled whenever you visit that record, use the
Current event of the form as well.
Click to expand...
 
Back
Top