Docmd FindNext Method in Microsoft Access
The Access DoCmd FindNext method performs the Find Next action in Visual Basic and is used in
conjunction with the
FindRecord
method.
This method has no arguments and is called simply by
using the command: DoCmd FindNext.
Some programmers create buttons to mimic Access's built in searching tools. In this case you would
place the DoCmd FindNext in the On Click event of the command button.
To set the search criteria, use the
FindRecord
action. Typically, you enter a FindRecord action in a visual basic or in a macro
and then use the FindNext action to find recurring records that meet your
criteria. To search for records only when a certain condition is met, you can
enter a conditional expression in the Condition option of the command for the
FindNext action. The conditional expression could be an if then expression
or a
select case
command.
Note that if you use the Find Record method in from a button on your form the
search will start at the 1st record and when activated again will find the same
record because when you click on a command button the form looses the focus of
the current records and therefore there is no current record from which to start
the search.
Additional information on DoCmd.Findnext VBA code:
The Access DoCmd.FindRecord method performs
the Find Record action in Visual Basic.This command is often used in
conjunction with the Docmd.FindNext. ...
www.blueclaw-db.com/docmd_findrecord_example.htm |
