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.
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
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