Option Group

[AN60]

At present I have a form which is used to select a date range then using one of three buttons I can select one of three reports. I want to use an Option Group with three options to replace the three buttons. I have fiddled around using three separate Option Buttons and they work ok but in my opinion they are not the way to go. I need some assistance with the code as the Option Group is slightly different to the Option Buttons.

 

[adevera]

You can use an Option Group wizard....

 

[AN60]

adevera
I have used the Option Group wizzard and have three nice option buttons to play with but I don't know how to tell these buttons how to open my reports?

 

[adevera]

On the After Update Event of the Option group, you have to test the value of option group. You can use SELECT statement or IF.

i.e: Select Case Frame0
Case 1:.....
case 2:.....
End Select

 

[AN60]

adevera
Thank you for your help. I must have been away the day my class learnt whatever you are talking about because I do not understand what you mean????

 

[AN60]

Thank you, I have the answer now and it is working ok.