Need help: FindRecord question (acSearchAll is not searching all)

[sdzc]

I am trying to create a button to quickly go to the next record with the same entry in a given field [Case Name]. It is working, but the search stops at the last record in the database and does not "loop around" and continue searching from the first record. I cannot figure out why acSearchAll is only searching UP and not continuing the search through the entire database. I am using Access 2003.

Here is the code I have:

Me![Case Name].SetFocus
DoCmd.FindRecord [Case Name], acEntire, False, acSearchAll, False, acCurrent, False

I thought changing the last False to True would work, but then it only searches to the very next record and does not do another search to the next match.

Any thoughts?

(my co-workers who want this are ragging on me to get it done)

 

[sdzc]

Any thoughts?

My co-worker "harassment" is elevating a little higher today... (at least it is friendly harassment)

 

[rainman89]

can u write a query instead? that looks for the record based on the txtbox?

 

[Wiz47]

You also have the option of creating a combobox and selecting the name of the employee (then have it go to that record) the combo can list all the names in alphabetical order so similar names will be next to each other.

 

[boblarson]

Me![Case Name].SetFocus
DoCmd.FindRecord [Case Name], acEntire, False, acSearchAll, False, acCurrent, False

This will only pull the first record that it comes across that matches the criteria. It doesn't do "FindNext." For that you will need to work out using DoCmd.FindNext

 

[sdzc]

When I try to use NextRecord, it stops after finding its first "hit" and does not go to the next successful match upon clicking the butting again.

Thanks for the responses so far.