>>Hi everyone.
>>I have main recordset with column ID, where ID is record identifier (primary key).
>>Than i have separate one dimentional array of those Ids.
>>What i need is to create new recordset from main recordset which only have records with those Ids,or may be exists other way to filter main recordset.
>>Thank you
>>Alex
>
>You could go back to the database to request this RS like so: (syntax not tested)
>
strList = Join(myArray, ",")
>myRS.Open "Select * From myTable Where col_id In (" & strList & ")", myConnection
>HTH
Thank you.