Whatever your .FIND criteria is you can phrase as a SELECT statement, e.g., Recordset.FIND "FIELD = " & value can be rephrased "SELECT Recordset.* WHERE (FIELD = " & value. Then execute the SELECT phrase as a command.EXECUTE or recordset.OPEN(sql)

.FIND is a sequential search going forward or backward according to the parameters VBfreak mentioned. SELECT is much more direct utilizing table indices.