I don't know if you have ever worked with MS Access but if so you should be ashamed.

This filter option you are talking about is an extra SQL-command that is used to limit the number of record listed. In order to do this fast and to remove it fast, microsoft gave us this command.

You can use it with a recordset, but also with a database. When you do it with a database, then all recordsets based on this database-object has the same filter.

When you change the database-filter, all the recordsets that are refreshed then take the new database filter. Enebling you to change a numoures count of recordsets with a single change.