SQL in module not giving correct result

[barien75]

Don't See why this won't work when want to omit these two values, seems to only omit one of the values

Case "68"
Forms.FrmBuilder.TxtHoldValue2.Value = "AZ"
Forms.FrmBuilder.TxtHoldValue3.Value = "321"

Forms.FrmBuilder.CboMaterial.RowSource = "SELECT TblMaterial.Material FROM TblMaterial WHERE (((TblMaterial.MatAbbr)<> Forms.FrmBuilder.TxtHoldValue2.Value AND TblMaterial.MatAbbr <> Forms.FrmBuilder.TxtHoldValue3.Value));"

also tried writing it as this which does same thing

Forms.FrmBuilder.CboMaterial.RowSource = "SELECT TblMaterial.Material FROM TblMaterial WHERE ((Not (TblMaterial.MatAbbr)=Forms.FrmBuilder.TxtHoldValue2.Value And Not (TblMaterial.MatAbbr)=Forms.FrmBuilder.TxtHoldValue3.Value));"



Both ways it is only omits one of the two values

This one works when I want to only select these two values
Case "60, 61, 62"
Forms.FrmBuilder.TxtHoldValue2.Value = "CS"
Forms.FrmBuilder.TxtHoldValue3.Value = "304/304L"

Forms.FrmBuilder.CboMaterial.RowSource = "SELECT TblMaterial.Material FROM TblMaterial WHERE (((TblMaterial.MatAbbr)= Forms.FrmBuilder.TxtHoldValue2.Value OR TblMaterial.MatAbbr = Forms.FrmBuilder.TxtHoldValue3.Value));"

 

[cheekybuddha]

Try:

Forms.FrmBuilder.CboMaterial.RowSource = "SELECT Material " & _
                                         "FROM TblMaterial " & _
                                         "WHERE MatAbbr NOT IN (" & _
                                           "'" & Forms.FrmBuilder.TxtHoldValue2.Value & "'," & _
                                           "'" & Forms.FrmBuilder.TxtHoldValue3.Value & "'" & _
                                         ");"