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.