Finding a Specific Record

The previous section, “Moving Through a Recordset,” explores ways you can use the Move methods — MoveFirst, MoveLast, MovePrevious, and MoveNext — to loop through a Recordset object. In most cases, however, it’s more efficient to search for a specific record.

For example, you may want to find a particular employee based on an employee number, or you may want to find all the order detail records that belong to a specific order. In these cases, looping through all the employee or order detail records could be time consuming. Instead, you can use the Seek method to locate records with table-type Recordset objects, and the Find methods with dynaset-, snapshot-, forward-only-, and dynamic-type Recordset objects.