FindWhat: Required
- an expression that evaluates to text, a number, or a date. This is where you
put the information for which you want to search.
Match: Optional - AcFindMatch can be
anyone of the following:
acAnywhere
acEntire (default)
acStart
MatchCase: Enter True for a case-sensitive
search and False for a search that is not case-sensitive. The default for this
argument is False.
Search:
Optional - AcSearchDirection can have any of the following values:
acDown
acSearchAll (default)
acUp
SearchAsFormatted:
Optional - use True to search for data as it is formatted and False to search
for data as it is stored in the database. The default for this argument is
False.
OnlyCurrentField:
Optional - AcFindField. can have any of the following:
acAll
acCurrent (default)
FindFirst: Optional - use True to start
the search at the first record. Use False to start the search at the record
following the current record. The default value for this argument is
True.
Also see the Access
Visual Basic FindFirst function for a recordsetclone.