I opened a recordset using the flag adLockBatchOptimistic. This way I can
make changes to the recordset and when needed, the changes are transferred
to the database using the "Update" method.
The problem is that when I use the Filter on such a recordset, it doesn't
see the changes I made until I use the Update method. How can I make the
Filter look through both the records that are already in the database and
the ones that are still in the recordset buffer?