Make Option Box appear if button is selected?

[TKM]

I have several reports in my combo box and I would like my option box to
appear if a user selects a certain report that is in my cbo. I have two
reports that I would like it to be visible on if they select those reports.
How would I go about this?

 

[Allen Browne]

Use the AfterUpdate event procedure of the combo to set the Visible property
of the option group.

 

[fredg]

I have several reports in my combo box and I would like my option box to
appear if a user selects a certain report that is in my cbo. I have two
reports that I would like it to be visible on if they select those reports.
How would I go about this?

Set the Option Group Visible property to No.
Code the Combo Box AfterUpdate event:

If Me![ComboName] = "Report1" Or Me![ComboName] = "Report2" Then
Me![OptonGroupName].Visible = True
Else
Me![OptonGroupName].Visible = False
End If

 

[TKM]

Fredg,

Thank you very much! works perfectly!

I have several reports in my combo box and I would like my option box to
appear if a user selects a certain report that is in my cbo. I have two
reports that I would like it to be visible on if they select those reports.
How would I go about this?

Set the Option Group Visible property to No.
Code the Combo Box AfterUpdate event:

If Me![ComboName] = "Report1" Or Me![ComboName] = "Report2" Then
Me![OptonGroupName].Visible = True
Else
Me![OptonGroupName].Visible = False
End If