AN Intelligent Search Facility?

[Richie2837]

Is there a way of getting the Search facility in Access to repeatedly cycle through all records until the user closes the Search window, rather than as it appears to be doing in our Contacts database at the moment - searching once through all the records then stopping?

 

[freakazeud]

re:

Hi,
if it would do that then you wouldn't be able to handle anything else in the application. Access can only execute one thing at a time and not parallel.
So you can't really even try to do this with a custom vba approach...but why would you anyway? Maybe you can clarify your goals a little more.
HTH
Good luck

 

[Richie2837]

I see what you mean. What I really want is for users to be able to search for a particular record, say the name "Harris", and if the users click "Next Record" when searching even though "Harris" has been found (i.e. the user clicked "Next Record" in error or didn't notice the record had been found), the the search facility goes through all the records again - i.e. each time "Next Record" is clicked, at the moment it searches once through all the records then tells us th record has not been found, meaning the user has to exit Search and re-run the search parameters.