Docmd FindRecord Method in Access
Access DoCmd.FindRecord method performs the Find Record action in Visual Basic.
This command is often used in conjunction with the
Below is show the FindRecord syntax and command line arguments:
Blue Claw Database Design is your premier source of Microsoft Access programming and database support. Both small business and department-level databases. Desktop installation as well as cloud/internet based solutions.
- 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:
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.
Optional - AcSearchDirection can have any of the following values:
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
Optional - AcFindField. can have any of the following:
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
Also see the Access
Visual Basic FindFirst function for a recordsetclone.