Print Report Using Option Group

[velcrowe]

I am working a reports but have never used an option group on a form so that I can change the criteria to print the same report for different parameters. I have my orders items (5 items) in one group and my years (2006-2009) in a second option group. How can I set up code with a print command button to prints reports for one order and one year at a time? Even if its one or two lines of code I really just need to see one case. Thank you

 

[pbaldy]

Personally I would not use an option group for years, given their dynamic nature. That said, if you want to do it you can give each option the appropriate year as its option value and simply have the query refer to the frame value.