Filtering w/o using a query from an "RS" - TechRepublic
General discussion
January 16, 2002 at 10:40 PM
gdhar_in

Filtering w/o using a query from an “RS”

by gdhar_in . Updated 24 years, 3 months ago

I had a recordset with a query select * from emp
I filtered it with rs.filter “Sal>” & varSal as i don’t want to use “query” for filtering.
Then I filtered again with rs.filter
“Job='” & varjob & “‘”. The problem is – it’s filtering the actual recordset rather than the sal filtered records. I want to give 2 conditions “sal> and job=” but vb is not accepting 2 conditions with filter. How can i filter with 2 conditions w/o(without) using a query but using a “filter” method of the recordset object

This discussion is locked

All Comments