Query with a Combo box to select requireed search field value

[swingtones]

Hi
I'm new user converting over from Lotus Approach. I'm using Access 2013.
I have a database with two tables being Suppliers and Products. This is a one to many type database with Suppliers being the one table.
Both tables have their own data entry forms.
In the Products table and data entry form is field named Category with a value list of about 20 different values.
The query I need to create is to search on the field value from one of the listed values in the associated combo box.
I have set up the basic query using the Query wizard. To run This I have to entry the value I wish to search for in the Query in Design mode.
My problem is now I want to drive the query from a new form.
On the new form I have created a combo box where the field list is the same as on the product data entry form.

I need to use this combo box to select the Category field value I need to search for and then click on the button to run the query. I seem to be stuck on the SQL code to achieve this
Any help or guidance much appreciated
Swingtones

 

[Brianwarnock]

To reference the combo in the query enter

Forms!formname!comboname

Brian

 

[swingtones]

Thanks Brian-problem solved !
swingtones