SQL Statement

[IanT]

Hi

Can anyone see why this sql statement errors!
Thanks in advance!

strNewRecord = "SELECT * FROM qryFurnitueTypesForm " & _
"WHERE qryFurnitueTypesForm.supplier" & strSupplier & " AND qryFurnitueTypesForm.fil1" & strType & "" & _
"AND qryFurnitueTypesForm.fil2" & strFil2 & " AND qryFurnitueTypesForm.fil3" & strFil3 & ""

 

[Mile-O]

strNewRecord = "SELECT * FROM qryFurnitueTypesForm " & _
"WHERE qryFurnitueTypesForm.supplier" & strSupplier & " AND qryFurnitueTypesForm.fil1" & strType & "" & _
"AND qryFurnitueTypesForm.fil2" & strFil2 & " AND qryFurnitueTypesForm.fil3" & strFil3 & ""

strNewRecord = "SELECT * FROM qryFurnitueTypesForm " & _
"WHERE qryFurnitueTypesForm.supplier = """ & strSupplier & """ AND qryFurnitueTypesForm.fil1 = """ & strType & """ & _
"AND qryFurnitueTypesForm.fil2 = """ & strFil2 & """ AND qryFurnitueTypesForm.fil3 = """ & strFil3 & """"

 

[modest]

Just so you understand what SJ gave you... you need to provide an "=" when comparing your field to your variable and you need to wrap your answer in quotes using (""") or (').

So:
"SELECT * .... WHERE fieldName = '" & varName & "'"
or
"SELECT * .... WHERE fieldName = """ & varName & """"