Record selection move

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
selecting a record from continuous form 3
Scrolling Text From Query 4
Search and insert into continuous subform 3
Select Specific Fields of Query Based On Variable Field 0
Access Automatically Send a notification email once a record is added 0
Filtering a form - wait 1
combo box not updating accoring to record selector 2

Back
Top