I am setting up a Form with an Option Group Frame of multiple Radial Buttons. Each button has a caption of what the button does. Example: Button one's caption is the name of a report it will print. etc...
There approximately 6 buttons with different report names and as with Managers and Supervisors the reports are changing or new ones added. I am using Case Statements in the Frame's On Update in properties.
This is what I'm trying to do is create a variable. The DoCmd has the report name hard coded in it, I know not good, so a variable is needed here. That's my problem, how do I capture the Button's Label Caption and set it as a variable eliminating the
hard coding. Here is a Case statement for button 1, "DoCmd.OpenReport "Cost Analysis", acViewNormal" and as things change so do Report Names, that is why I need to set a variable set up.
Do not need someone entering the program to change the Report Name or the Label Caption to reflect new reports. Programmatically changing the Label Caption name is another issue to address later.
Are there any ideas on the variable issue?
Thank you...