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.