The following scenarios are available for searching recordsets:
Using a SQL query with a WHERE clause to constrain the recordset
Searching with the Find method
Setting Filter conditions
In general, you should always use the first scenario for working with recordsets. It is always faster and easier to select Access records based on a query or a SQL character string.
However, there are exceptions: For example, to minimize network traffic, it can be useful to open a recordset with a static cursor and import all data to the client, then search and filter the data in the recordset. This section does not address the option of using a SQL command to constrain a query’s resultset. Instead, we introduce the methods for searching and ...