Record selection move

C

Cameron

I am working on a search routine on a continous style form, and would like
once the first record is found in the search to have the form scroll to that
record. I am searching for certain text entries and have corrisponding ID
numbers. How do I have the search scroll down the records to the first
instance of the text the user has searched for?
 
M

Marshall Barton

Cameron said:
I am working on a search routine on a continous style form, and would like
once the first record is found in the search to have the form scroll to that
record. I am searching for certain text entries and have corrisponding ID
numbers. How do I have the search scroll down the records to the first
instance of the text the user has searched for?
Click to expand...


Your search code should look something like:

With Me.RecordsetClone
.FindFirst "thefieldtosearch = """ & searchtextbox & """"
If Not .NoMatch Then Me.Bookmark = .Bookmark
End With
 
Top