cansevin
asked on
Make check box visible only if a specific option is checked
I have an option group that has 8 options. If the first option is selected, I would like two other check boxes to be visible. If the first option is not selected, then the two check boxes would be invisible.
Any ideas?
Thanks,
Chris
Any ideas?
Thanks,
Chris
ASKER
Thanks... unfortunately I am not that familiar with VBA. Can I put that code in an event for "After update"
Sorry... I am an idiot at this.
Sorry... I am an idiot at this.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In most cases, you need to include BOTH sides of the condition.
Note that you need to check the value of the option group, NOT individual controls inside the option frame.
If you go with the macro (I don't think it is easier and I never use them), add the false option there.
If Me.fraSelection = 1 Then
Me.chkFld1.Visible = True
Me.chkFld2.Visible = True
Else
Me.chkFld1.Visible = False
Me.chkFld2.Visible = False
End If
Note that you need to check the value of the option group, NOT individual controls inside the option frame.
If you go with the macro (I don't think it is easier and I never use them), add the false option there.
Say checkbox1 is your 'control' and checkbox4 and checkbox5 are your 'variables', you could use:
Open in new window
It is hard to say without verifying the source.