Hello,

Is there a quick way to compare a string against an array of strings to see if it exists without having to loop through? Also, what is the max count an array can have and what is the longest string it can hold?

Code:
Dim myArray() As String

Do Until rs.EOF
  'check rs![Field1] vs array, if it does not exist then add it
  rs.MoveNext
Loop
Thanks,
Thai