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

Chapter 16. Retrieving Data with ADO > Filtering Recordsets

Filtering Recordsets

Searching for specific data in a Recordset object is easily accomplished using the Filter property. You can submit a new query or even use the Find method (which is discussed in the next chapter), but Filter is truer to the purpose of a criterion-based search. Submitting a new query completely changes the results of the Recordset and Find locates appropriate data one record at a time. The Filter property/method temporarily limits access to only those records that meet the filtering criteria. In other words, you end up with a subset of records from your Recordset.

When temporarily restricting the available records in a Recordset, use the Filter property in the form


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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