filter a DAO recordset

[rfoye]

I have a form that is based on a fairly complex SQL string that includes a WHERE clause. I have another form where the user enters search terms in 5 possible fields that sets further WHERE conditions for a filter of the first form. The filtering works fine if there are matching records. However, I'm having a hard time figuring out how to test for and trap a result set of 0 records. If I set the filter on for the form, it starts requerying before it will test to see if the new dataset is null.

I tried creating a DAO recordset clone of the initial form. I can set rsClone.filter -- but there is no .FilterOn method for the recordset. What step have I overlooked?

-------------------
Rob Foye
Database Management
Regions Bank

 

[ZmrAbdulla]

May be PHV's answer to this thread181-1041815 will help you.

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.