SQL Query on Access Form

[BrianFawcett]

I am trying to write a SQL qurey on a access form but am struggling with the terminology.

The query should take what the user selects from three drop down lists (combo boxes) and filter the results to show only those records which match.

The combo boxes are cbCatergory, cbSupplier, andcbPartNumber with the field in each being Category, Supplier and Part

I cannot figure out what my WHERE clauses need to be written as

[pbaldy]

Sounds like a cascading combo type of thing:

Baldy-Cascading Combos

[TheShabz]

I dont think he's referring to making the combos based off eachother. I think he just wants to use the value of the combo boxes in his WHERE clause.

WHERE table.field = Forms!myForm!cbCategory AND table.field = Forms!myForm!cbSupplier AND etc.....