Search then search next

[Nasdawg]

Hello all,

I have search feature in my database. But now I have multiple records with some of the same fields. So what i would like to do is have a button that will search for the next record. Anyone that can help me I would appreciate it.

Thanks in advance

 

[M8KWR]

when you use your search feature do you activate this to the form?? If you did then you could use the next/previous buttons to display the next records that matches the criteria of your search!!!!

 

[Nasdawg]

NO this is what i use for my search

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "

='" & Me.srch & "'"
   If Not rs.nomatch Then
   Me.Bookmark = rs.Bookmark
   Else
   MsgBox "'" & Me.srch & "' found in the Database"
   End If

something very simple

 

[PHV]

Have you tried rs.FindNext ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Nasdawg]

thanks for your assitance I have figured it out with your help