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:
Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. Experts in small business management and scientific database programming.
Do you and your clients need access to data on the Internet? We can create a secure system to match your requirements perfectly.
- 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.