Results 1 to 2 of 2
2001-11-13, 14:35 #1BillyMo11Guest
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.
2001-11-13, 18:04 #2
- Join Date
- Nov 2001
- Illinois, USA
- 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.