You can use the FindNext action to find the next record that meets the criteria specified by the previous FindRecord action or the Find In Field dialog box, available by clicking Find on the Edit menu. You can use the FindNext action to search repeatedly for records. For example, you can move successively through all the records for a specific customer.
The FindNext action doesn’t use any arguments. The FindNext action finds the next record that meets the criteria set either by the FindRecord action or in the Find In Field dialog box. The arguments for the FindRecord action are shared with the options in the Find In Field dialog box.
To set the search criteria, use the FindRecord action. Typically, you enter a FindRecord action in a macro and then use the FindNext action to find succeeding records that meet the same criteria. To search for records only when a certain condition is met, you can enter a conditional expression in the Condition box of the FindNext action.
This action has the same effect as using the Find Next button in the Find In Field dialog box.
Note While the FindRecord action corresponds to Find on the Edit menu for tables, queries, and forms, it does not correspond to Find on the Edit menu in the Module window. You can’t use the FindRecord action or FindNext action to search for text in modules.
Tip If you’ve set the Only Current Field argument of the FindRecord action to Yes, you may need to use the GoToControl action to move the focus to the control containing the data you’re searching for before you use the FindNext action.
To run the FindNext action in Visual Basic, use the FindNext method of the DoCmd object.
FindNext Method, FindRecord Action.