1,105,625 Community Members

recordset where value equals loop through array value

Member Avatar
Newbie Poster
5 posts since Jan 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]


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))

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

"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

This article has been dead for over three months: Start a new discussion instead
Start New Discussion
View similar articles that have also been tagged: