Finding multiply matches for a record (Visual Basic 6.0)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote