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