Remove a Filter from a Recordset

[BarkerD]

How do I remove a filter from a DAO type recordset.

I need to use Filter instead of FindFirst, Seek because I need to access the RecordCount property.

I tried using:

rst.Filter= ""
No Luck

I also tried
rst.Filter = adFilterNone
Not sure if that worked either

I am using this inside a transaction, so I cannot close the recordset and re-open it. I access this particular recordset in about 4 different places in my code.

I have checked and double checked to confirm that the criteria string is correct.

*Baffled*

Thanks for any help

Duane Barker

[This message has been edited by BarkerD (edited 11-10-2000).]

 

[mike wild]

try this

DoCmd.RunCommand acCmdRemoveFilterSort