Muliplte fields in SQL WHERE statement

[BrianFawcett]

I am writing a query where my WHERE statement has a combo box which contains two fields for the same table in it. How do I writre the WHERE statement to inclde two fields, I tried different thing but cannot get the first half of it to work:

WHERE(field1 + field 2) = Forms!mainForm!cbSupplier

The two field are tblSuppliers.SupplierCode and tblSuppliers.SupplierName

 

[rainman89]

if cbsupplier is a combo box with a bound column, you will only need to do the one supplier code. It is not necessary to do both code and name since they are tied to each other in the table, presumably of course.