Need a form to select opt. buttons, then report to show details

[myztiques]

I have a Access form with option buttons that is completed by the user. I
want to make the process as easy as possible for the user to click on the
options that is applicable for the customer. Then when I create a report
that if an option button is selected it will actually pull a list of items
and display them on the report. Just in case, I am not explaining it
correctly, here is an example: In the Form, I click the option for Tractors
and then go to the report and the report will actually show the brands. On
the other side of this, I also want to have the report not show the options
not selected. Is this possible and if so, how!!!!! Help!!!!

 

[Ken Snell \(MVP\)]

Assuming that the "brands" data are being displayed in a subreport in the
report, and assuming that you're using ACCESS 2002, 2003, or 2007, use the
OpenArgs argument of the OpenReport action to pass a value to the report
that tells the report whether the option button was "on" or "off", and then
use the Format event of the report's section that contains the subreport to
make that subreport visible or not visible.