Conditional disabling of "check boxes"

[DH]

Any one out there know how to conditionally enable/disable a check box on a form?

Conditional Formatting in Access 2000 from the format menu doesn't seem to apply here.

I would like to enable/disable a check box depending on user input that appears at the beginning of a form.

For example, If the user answered "great" to a question I would like a check box that appears later in the form to be disabled. However if the user answered "bad" to the question I would like the check box to be enabled.

Any ideas?

 

[RickSpr]

Simple. Just use the AfterUpdate event of the earlier control to test its value and set the check box's Enabled property appropriately. For example:

   Private Sub txtEarlier_AfterUpdate()
      If txtEarlier.Value = "great" Then
          chkCheckBox.Enabled = False
      Else
          chkCheckBox.Enabled = True
      End If

Rick Sprague

 

[ghubbell]

On After update event of your "GreatBad" field add code:
If Me.GreatBad = "great" then
Me.CheckBoxname.Enabled = False
Else
Me.Checkboxname.Enabled = True
End if