Option Group to Enable or Disable a button

[mmg]

I am trying to figure out how to enable or disable a button based on a selection from an option group. I have an option group with "Yes" and "No".


If the radial button is selected to "Yes" I would like the button enabled to open a form. If the radial button is selected to "No" I would like the button to be disabled. Would anyone know how to fix this and I am trying to also learn VBA, Thanks in advance.

[pbaldy]

See if this gets you started:

http://www.baldyweb.com/ConditionalVisibility.htm

[Missinglinq]

Option Groups don't have Values like "Yes" and "No," their Values are Integers! If the Label on your first Option Button is "Yes" and the Label on the second Option Button is "No," this code should do the job:

Private Sub YourOptionGroupName_AfterUpdate()
 If Me.YourOptionGroupName = 1 Then
  YourCommandButton.Enabled = True
 Else
  YourCommandButton.Enabled = False
 End If
End Sub

Private Sub Form_Current()
 If Me.YourOptionGroupName = 1 Then
  YourCommandButton.Enabled = True
 Else
  YourCommandButton.Enabled = False
 End If
End Sub

Simply replace YourOptionGroupName and YourCommandButton with the actual names of your Controls.

Linq ;0)>