Find function is used to locate a particular string in a dynaset or snapshot type recordset using a comparison operator. In general, it is better to create a new query that retrieves the records that is required instead of using Find function in the DAO recordset. This is true especially with ODBC data. On ODBC data, you should use Find only on indexed fields. It is otherwise more efficient to open a new recordset using a SQL statement with an appropriate WHERE clause. Always remember that smaller the set of records you have, the more effective Find will be.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
