RECORDSET,open where multiple clauses

[tinak65]

HI

I am having issue with recordset when my where clause has more than 1 field
'objRecordSet.Open "SELECT SalesOrder,SalesOrderLine FROM tbl_SorDetail_OtifAudit WHERE SalesOrder = '" & OrderHeader.CodeObject.SalesOrder &"'"
this works correctly
but I don't know correct way to add where SalesOrderLine = & OrderHeader.CodeObject.OrderLine &
I have tried numerous ways and all return recordcount = 0 when know that is not correct

any help much appreciated
Tina

[techgnome]

Nothing special about it at all... it's just an additional AND in the where

"SELECT SalesOrder,SalesOrderLine FROM tbl_SorDetail_OtifAudit WHERE SalesOrder = '" & OrderHeader.CodeObject.SalesOrder & "' AND SalesOrderLine = "' & OrderHeader.CodeObject.OrderLine & "'"

-tg