FindFirst, FindLast, FindNext, FindPrevious Methods Example 1

This example finds the first record matching the specified criteria, and then finds the next matching record.

Dim MyCriteria As String
MyCriteria = "State = 'NY'"              ' Set the criteria.
Data1.Recordset.FindFirst MyCriteria     ' Find first matching record.
If Not Data1.Recordset.NoMatch Then...   ' Check if record is found.
...
Data1.Recordset.FindNext MyCriteria      ' Find next matching record.