Make Option Box appear if button is selected?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Use the AfterUpdate event procedure of the combo to set the Visible property
of the option group.
 
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?
Click to expand...

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
 
Fredg,

Thank you very much! works perfectly!

fredg said:
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?
Click to expand...

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
Click to expand...
 
Back
Top