Results 1 to 2 of 2
  1. #1
    BillyMo11
    Guest

    Finding multiply matches for a record (Visual Basic 6.0)

    I have a function that searches a recordset and then displays it. But I am having a problem of I want a message box to come up with the search finds multiply records that match. And then be able to have user push a button to view the next record.

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Location
    Illinois, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding multiply matches for a record (Visual Basic 6.0)

    You could use the Filter property of the recordset to get the records matching the search criteria; the filtered recordset's RecordCount property will then give the number of records meeting the criteria. You can use the usual navigation methods, like MoveNext, to let the users move thru the filtered records. When you want to look at the unfiltered original recordset again, just set the Filter property to adFilterNone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •