oRs.Find sCriteria, nSkipRows, nSearchDirection, vStart
|sCriteria||(String) The value that contains a statement specifying the column name, comparison operator, and value to use in the search. For example "Country='Czech republic'", "Date>#7/22/2011#", "Country LIKE C*", etc.|
|nSkipRows||[optional] (Long) Specifies the row offset from the current row or vStart bookmark to begin the search. The preset value is 0.|
|nSearchDirection||[optional] (Long) The value that specifies the search direction:|
1 (default) - (adSearchForward) Searches forward from the starting position. If no match, then the record pointer is placed after the last record (EOF).
-1 - (adSearchBackward) Searches backward from the starting position. If no match, then the record pointer is placed before the first record (BOF).
|vStart||[optional] (Variant) Define the starting position (Bookmark). If not set, then the starting position will be the position of the current active record. If a valid Bookmark is defined, then it will be used as starting position. It is also possible to use standard numeric constants for defining the start position:|
0 (default) - (adBookmarkCurrent) Current record.
1 - (adBookmarkFirst) First record.
2 - (adBookmarkLast) Last record.
Dim oDb, oRs
oRs.Find("name='pi'", 0, 1, 1)