recordset where value equals loop through array value

[kaden712]

Hi

Please can some one help me urgently with this
I have the following code

<%
Dim productColors, myString, myArray
myString = (prodRS.Fields.Item("prodColor").Value)
myArray = Split(myString,",")
Dim counter
for counter = 0 to UBound(myArray)
  productColors = (myArray(counter))
  Next
%>

Which works as intended in splitting the string

What I now wish to achieve is a Recordset from another table
which will return records with the same values as returned by the split string function

eg:
"SELECT * FROM tbl_color WHERE colorCode = ????"
???? being each of the values returned by the split string function

If it makes a difference I am using an Access Database

Thanks in anticipation