Attached find DB than illustrate my problem. In the DB you will find that there is more than one client with the same [lastname] as Brown. Every time I time I type Brown in the unbound search txt box and click on cmdSearch only the first Brown is found I can't get to the 2, 3rd and so on.



I don't want the search to be link only to the [lastname] but rather any field and also I do not want to type in whole field I want to search but only part thereof. In other words I want the search action to work the same as the build in Access search function but without calling up the search msg box.

You will find the code that I used behind the cmdSearch in the attached DB.


Regards
Johan