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.....
Printable View
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.....
Either of the following will work:
1) rs.Filter = ""
2) rs.Filter = adFilterNone
Simon.