conditional checkboxes..

[katie george]

Hi -

I am struggling with the following scenario if anyone could give me some help that would be great..

I have an option group with 3 checkboxes:

Security
Fleet Management & Security
Fleet Management

The user can select one of these options. I also have a second option group with two checkboxes, passive and active. I want to automate this such that if the user selects either security or fleet management & security the second option group becomes visible and enabled. Currently the user can select fleet management and either active or passive and they shouldn't be able to..

Hope that makes sense

Thanx in advance

 

[KeithWilliams]

Hi,

I think you need to code the following in the Change event of each of the first 3 checkboxes:

If Me.FleetManagement = True Then
Me.Passive.Visible = False
Me.Active.Visible = False
Else
Me.Passive.Visible = True
Me.Active.Visible = True
End If

Not sure if there is a more appropriate event to use with an Option Group. If you do have to code it 3 times then you might want to put the code in a sub and call the sub from the 3 event scripts.

Hope that helps,
Keith.