I created a disconnected ado recordset when a form is open
When I open the form in datasheet view, all data is shown correctly.
However, when I right-click and use the built in Filter I recieve either "Cannot apply filter on one or more fields specified in the Filter property" or "Data provider could not be initialized"
Could you please tell me how can I apply filter using disconnected ado recorodsets
Your help is highly appreciated