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
