Docmd FindNext in Microsoft Access


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 theFindRecord 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:

Docmd FindRecord
The Access DoCmd.FindRecord method performs the Find Record action in Visual Basic.This command is often used in conjunction with the Docmd.FindNext. …


Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016