After Using a filter on the Recordset how do you release the filter?

sjmmajor
sjmmajor used Ask the Experts™
on
After Using a filter on the Recordset how do you release the filter?  Here is my code.

DataEnvironment1.rsCmdshiftcurrent.Filter = "Date=#" & selectdates & "#  and time = '1400'"

Then I want to use the same recordset and get the last entry in the database.  I am using the code:

DataEnvironment1.rsCmdshiftcurrent.MoveLast

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
have you tried:

DataEnvironment1.rsCmdshiftcurrent.Filter = adFilterNone

Author

Commented:
Thanks that worked!! Thanks for your quick response.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial