Creating reports in Access 2010 (1 Viewer)

[jessss]

HI

I have a database in Access 2010 which has 3 tables (OEM, Products & Support) and a form (SupportForm).

I now want to create a report which has two drop down boxes (linked to 2 columns in the Support Table, Field2 and Field3) on it, which when choices are selected from them they will run a query which will select different columns in the Support table using the criteria selected in the two drop down boxes.

For example if the user selects "1" from the 1st drop down box and "All" from the second, i want the data on the report to show all the rows in the Products table which has 1 in the Field2 and all the rows in Field3.

However i know however to attach a query to teh report but i am not sure how to create the query and have the report run the query with criteria selected?

Can anyone help me? I am very sorry if this question is difficult to understand.

Thanks

Jesss

 

[cookiegary01]

Hi Jesss,
Need some answers from you before a good answer is possible:
Your form containing the drop downs is called?
What is the name of 1st drop down?
What will the 1st drop down select?
Is the 1st drop down "bound column" an auto ID?
The same answers are needed for Drop down2
Are your tables related?