Search Multiple tables on multiple worksheets - find next/ previous item.

Morning All,


I have a search option on my Userform enabling the user to search via Client or Opportunity name, and use the below code to find the result and populate various text/comboboxes on the search form. This enables the user to check it is the correct record before selecting it, please see attached as trying to wrap in CODE tags I get a SQL error.


This works well when searching by Opportunity Name as this is a unique value. However, when searching by Client there could be multiple results so I need a way of moving to the next or previous record (Just in case the user gets click happy). To facilitate this, I have included a Next and Previous button on the search form - I'm just not sure how to code the functions to get them to work, or if I need to change my main search code above to get this all to work.

So any help you can give would be greatly appreciated as this is the last piece of the puzzle to get my Userform up and running.

For clarity, I have also posted this on Mr Excel (I cannot include the link, as I get the following error: You are not allowed to post any kinds of links, images or videos until you post a few times. )

However, it's been 5 days without a reply, so I though it would be OK to post here, to see if there's any response.

Thanks