Hiya, here is some SQL:

SELECT Distinct Left$(Code, Len(Code) - 2) As CodeNum, O2, CO2
FROM Resin
WHERE (Right$(Code, 2) = " & cmbGoalTemp.Text & ")
AND (InStr(1, " & strresins & ", CodeNum, vbTextCompare) > 0)

I get this error: "No value given for one of more required parameters"

it's on this line:" AND (InStr(1, " & strresins & ", CodeNum, vbTextCompare) > 0)" im pretty sure because it worked before i added that.

the code field is full of values like this:
ax10
ax20
ax30
bc10
bc20
bc30
g110
g120
g130

and strresins looks like this: "ax,bc"

Can anyone tell me wat's wrong with it?

Thanks for your time
Ang