Option group and command buttons

[Mansoor Ahmad]

Dear All

I have got a little query about option group and VB codes. I explain my problem here

I have got set up an option group with 4 options and 7 command buttons each opens a different report based on the selected option.

Now the problem is do I have to write separate VB codes on each command button's OnClick event to open different reports depending on one option selected in option group?

What I want is,

If option1 is selected and CmdReport1 is clicked, it would preview or print Report1 and if CmdReport2 is clicked, it would preview or print Report2 and so on.

The only problem with the present situation is that there would be huge list of codes in VB window and it would become complicated to handle.

I hope I have explained my problem.

Looking forward to your reply.

Thanks

 

[AlienRay]

What is the purpose of the option buttons? How do they influence what report gets generated? Are there 28 separate reports, or just 7 reports that, say, get sorted 4 different ways?