How to user Filter with a RecordSet?

[Michel Jr]

Hi,

I have been populating a RecordSet with all the records of a table:

Set Rst = New ADODB.Recordset
wSQL = "Select * from CUSTOMERS Order by CustName"
Rst.Open wSQL, Conn, adOpenDynamic, adLockOptimistic

How can I find a specific record in this RecordSet using the Filter method?

Note: If I find the record I'm looking for, I need to delete it and move the pointer of the RecodSet to the Next record or Previous record.
I can't re-populate the RecordSet every time I delete a record (it has a lot of records and I think this would be a little slow).

I think that the Filter method is the best way to solve this, but how to use it?

Thanks in advance...

Michel Jr.

[morphman2000]

Why don't you just refine your query to it?

Like this:

Set Rst = New ADODB.Recordset 
wSQL = "Select * from CUSTOMERS where CustName = ' Michel'  Order by CustName" 
Rst.Open wSQL, Conn, adOpenDynamic, adLockOptimistic

You recordset will only contain the records which contain Michel in the field 'CustName'.

easy...

Big benefit is that your recordset is not so big.

[Bigley]

Not that I don't have the same concerns as Morphman2000

Rst.Filter = "CustName = '" & varName & "'"