Find - Find Next

[Guest]

Hello, i have a form with a find button.
This find button stops at the first record that matches the search criteria.
What i'd like to do is to implement a Find Next button. Is there any type of
button that does this type of search or do i have to programme a button?

 

[Michel Walsh]

Hi,


With Me.RecordsetClone
.Bookmark = Me.Bookmark 'synch the clone with the form
.FindNext strCriteria ' find next, from the actual position
If .NoMatch then
.FindFirst strCriteria 'if not found, find first
End If
If .NoMatch then ' if not found, mentions it
MsgBox "Not Found"
Else ' otherwise, sychn the form with the clone
Me.Bookmark = .Bookmark
End If
End With


Hoping it may help,
Vanderghast, Access MVP

 

[Marshall Barton]

Hello, i have a form with a find button.
This find button stops at the first record that matches the search criteria.
What i'd like to do is to implement a Find Next button. Is there any type of
button that does this type of search or do i have to programme a button?

Program it yourself. Depending on how you've done the find,
the code could be almost exactly the same except that you
would use the FindNext method instead of the FindFirst
method.