I have an Option Group with 7 Radial Buttons and the label is the name of a different report for each button.
I am using Case Statements for each button and what I would like to do is have each Case Statement look for the label name and place it in the DoCmd that opens the report for preview. What I have working now is nice, but, I have to hard code the report name in the DoCmd line.
Like this:
Case 1
(DoCmd.OpenReport "Report Name1", acViewPreview)
Any ideas on how this can be done?
I am using Case Statements for each button and what I would like to do is have each Case Statement look for the label name and place it in the DoCmd that opens the report for preview. What I have working now is nice, but, I have to hard code the report name in the DoCmd line.
Like this:
Case 1
(DoCmd.OpenReport "Report Name1", acViewPreview)
Any ideas on how this can be done?