Hello all,

             I have opened a recordset containing 15000 rows(Recordset from Item table having the code and name of items).
Now when i try to apply filter at this recordset

Recordset.filter = "ItmName Like '%amox%'"

According to me it should give me all the items having words "AMOX" in its name at any place.

But visual basic shows an error that "Filter can not be open".

If anyone can help.... it will be highly appreciated..

                             Regards,

Tiyyob

__________________
Tiyyob