Radio Buttons

[kathrync2003]

Hello.

I have constructed a form which has 7 radio buttons named optSort1, optSort2, etc. and have set the 1st radio button on.

I have a button on my form that when you click it, I need it to determine which radio button was selected and run the appropriate report based on this.

My reports are named rptSort1, rptSort2, etc.

Any help would be appreciated.

Thank you.

 

[FancyPrairie]

If your buttons are part of an Option Group, then use the value of the option group to open your report. For example, suppose the name of the option group was "MyReports". Then via the OnClick event of your button, do something like this:

DoCmd.OpenReport "rptSort" & MyReports.Value

 

[kathrync2003]

Thank you.

 

[SilentAiche]

Kathrync,

How 'bout "Thank you" plus a star for FancyPrairie? Just click on the link in the lower left corner of her post (the one that says "[blue]Thank FancyPrairie for this valuable post![/blue]"

Kathy, I'm kind of a newbie here, so forgive my impertinance, but some of these folks are amazingly generous in sharing their knowledge, and I really like saying Thank You. Besides, a one-post answer is the very best kind!

Best Wishes in all your Quests!

Tim




[blue]__________________________________________________
If you need immediate assistance, please raise your hand.[/blue]