Using option buttons in a form, then report for only opts. selecte

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!
 
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!!!!
Click to expand...

Base the Report on a Query selecting the appropriate options, using a
criterion like

=Forms!NameOfYourForm!NameOfYourOptionGroup

on the (numeric) table field containing the option. The query should join this
numeric field to whatever table contains the brand name.

John W. Vinson [MVP]
 
Back
Top