Hi,
I created this search userform with help from various people from this forum and it works great but recently a problem has arisen that I now need it to be able to return multiple answers.
So basically at the moment the userform finds the first order number matching the order number entered into the search userform and then fills out the fields to suit.
On the Changeover Form sheet, the last few order numbers I have changed to 12345678.
What I would like is when 12345678 is entered into the search userform it returns all 7 entries.
A maximum of 10 returns should be enough.
I appreciated I will have to change a lot of things around or even start again, which is fine. I would just like someone to point me in the right direction in how to get started and what is the best way of doing this.
Any help on this would be much appreciated.
Kind Regards
Dan
Bookmarks