See Also Example
Table object, Dynaset object, Snapshot object .
Indicates whether the FindFirst, FindPrevious, FindNext, FindLast, or Seek method was successful in finding a record. Not available at design time; read-only at run time.
The NoMatch property settings are:
True A Find method or the Seek method failed (the desired record wasn't found).
False A Find method or the Seek method was successful (the desired record was found).
When you first open or create a recordset or data control, NoMatch is False.
With the Recordset property of a data control, use one of the Find methods to make a specific record current In the Professional Edition only, you can also use any of the Find methods with a Dynaset or Snapshot object, or the Seek method with a Table object..
After using a Find method or the Seek method, inspect the NoMatch property to see whether the record was found. If the operation fails (no matching record is found), the NoMatch property setting is True and the current record is undetermined. If a matching record is found, NoMatch is False.