Clearing Filter Recordsets

[adam01]

Hello. My question is relatively simple for all of you but bear with me. How can I clear a recordset after I have used a filter on it? i.e. I want the original recordset before the filter. Thanks in advance.....

[simonm]

Either of the following will work:

1) rs.Filter = ""

2) rs.Filter = adFilterNone


Simon.