Find

Syntax

recordsetobject.Find Criteria[, SkipRecords][, SearchDirection][, Start]

Description

Searches for a row in a Recordset that matches the given criteria.

The Find method is used to search a Recordset for a Record that matches the search criteria (a search string). This method will work if the Recordset supports bookmarks. If the search is successful, the current record pointer will be moved to point to the first Record that matches. If the search fails, the Recordset will point to either EOF or BOF.

There is one mandatory and three optional parameters.

You can only search on one field (column).

The comparison operators in Criteria can only be one of the following:

= > >= < <= <> LIKE

You cannot use OR or AND.

The value in Criteria can be a date, number, or string. If the value is a string, it must be enclosed (delimited) within a pair of single quotes ("State = ' Tennessee' ") or a pair of pound signs ("State = #Tennessee# "). If the value is a date, it must be enclosed (delimited) within a pair of pound signs ("Birthdate = #6/26/1943# "). Numbers are not delimited ("Age = 104").

If you are using the LIKE operator, you can also use the asterisk * wildcard either after the value in Criteria or before and after the value in Criteria ( "LastName LIKE ' * stein * ' " or "State = ' T * ' ). Some providers also support using the % and _ wildcards.

Parameter	Description
Criteria	The mandatory Criteria parameter is a string that defines the search criteria. This string must contain one field (column) name, one comparison operator, and a search value.
SkipRecords	The optional SkipRecords parameter is a long value that specifies how many records beyond the current record to skip to before starting the search. The default is zero which means that the search starts at the current record.
SearchDirection	The optional SearchDirection parameter is one of the SearchDirectionEnum constants that specify which direction the search should proceed, either forward or backward. If no matching record is found for a forward search, the record pointer is set at EOF. If no matching record is found for a backward search, the record pointer is set at BOF.
Start	The optional Start parameter is a variant that is either a bookmark or one of the BookmarkEnum constants that indicates the starting position for the search. The default is to start at the current record.

SearchDirectionEnum Constants

Constant	Value	Description
adSearchBackward	-1	Searches from the designated starting point backward to the first record
adSearchForward	1	Searches from the designated starting point forward to the last record

BookmarkEnum Constants

Constant	Value	Description
adBookmarkCurrent	0	Default, start search at current record
adBookmarkFirst	1	Start search at first record
adBookmarkLast	2	Start search at last record

See Also

BOF, Bookmark, EOF, Index, Seek, SQL.RunQuerySearch.

Example

varBookMark = rsChantList.Bookmark

rsChantList.MoveFirst

rsChantList.Find "ChantName = 'Oma' "

If (rsChantList.BOF = True) OR (rsChantList.EOF = True) Then

MsgBox "Record not found"

rsChantList.Bookmark = varBookMark

End If