>>Dim rs As Recordset
>
>Note that instead of Recordset, you may have to specify ADODB.Recordset, depending on what references are checked for your project. Both ADO and DAO have RecordSet objects.
>
>Also, using a Filter tends to be slow. It is often quicker to create a new recordset with the SELECT criteria instead of implementing a Filter on an existing Recordset.
>
>Best,
>
>jody
I agree with Jody on that one.