Macro Trying to run different reports based on option selected.

[jstew]

I'm having a problem trying to make this work. I have an option group that has three radio buttons. Depending on which option is selected I want to run a different report. It's really a criteria selector. After I select the criteria, I want to add criteria in a text box and hit search command button. I have tried to make this work using a macro, but no success. I can get the first option to work, but if I select any other option in the group it gives me an error, something to the effect of expression wrong. Can't remember exactly now, have tried multiple configs of this thing. Anyways, hopefully I've managed to convey my problem well enough so that someone can understand me. Thanks for the help.
jstew

 

[jrbarnett]

Not sure if this will help, but it covers in detail how to create a flexible report selection form with VBA necessary.

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=3619

John