Link to home
Start Free TrialLog in
Avatar of sjmmajor
sjmmajor

asked on

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

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

ASKER CERTIFIED SOLUTION
Avatar of vinnyd79
vinnyd79

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sjmmajor
sjmmajor

ASKER

Thanks that worked!! Thanks for your quick response.