• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

16. Programming DAO: Data Manipulation L... > 16.4. Finding Records in a Recordset

Finding Records in a Recordset

The method used to search for a record in a recordset is different for indexed table-type recordsets than for other recordsets.

Finding Records in a Table-Type Recordset

To locate a record in an indexed table-type recordset, you use the Seek method. Note that the recordset’s Index property must be set before the Seek method can be used. The syntax of the Seek method is:

TableTypeRecSetVar.Seekcomparison, key1, key2,...

where comparison is one of the following strings:

"<"
"<="
"="
">="
">"

and key1 , key2 ,... are values corresponding to each field in the current index.

Notes

  • The Seek method searches through the specified key fields and locates the first matching record. Once found, it makes that record current, and the NoMatch property of the recordset is set to False. If the Seek method fails to locate a match, the NoMatch property is set to True, and the current record is undefined.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint