Populating textboxes based on multiple combobox selections

Hi all, I currently have a userform that has 4 comboboxes, all filtering from a table, with the last combobox being filtered to a single row match in the table. Once that match is made, textboxes are filled with the data contained in the adjacent row in the table.

I am using the below code to fill in these textboxes

Please Login or Register  to view this content.

This all works fine, but the search is only being constrained to the selection made in the final combobox, this would be fine however, that value is not unique in the table, so I am missing rows of data in the results of my UserForm. So my question is if I can constrain the search to all the combobox selections rather than just the last one.

Any assistance would be greatly appreciated as I've completely hit a roadblock with this. I attached the file below

Amazing! Thank you so much for your help.

One last question, could this be applied to the textbox based search located on the left hand side of the form?