Userform selection yields wrong information

Greetings everyone!

I have a problem and I was hoping for some help from the guru's.

I have a workbook (see attachment) with a searchable userform. The problem I am having is that when there is multiple entries of the same persons name and a selection is made from the listbox, the wrong line is displayed in the fields below. I believe the selection is only pulling the first entry in the list, no matter which entry is selected. Any suggestions as to how i could modify the code so that the correct details are pulled into the textboxes? Thanks in advance for any help you can offer.


Problem can be created by: 1. search for the name "David". A list of four entries will appear. 2. Double click on the second, third or fourth line and you will see that the textboxes do not pull the correct date among other fields.


The rest of the form works beautifully.


Any help would be appreciated!


Sincerely,

David

Hi there,

Nice UserForm!

It's a bit complicated so I've had just a very quick look at it, but it seemed to work correctly for me when I changed the TDCJ # field to unique values - in your post all of the records for David Oney contain a value of 123456789 for the TDCJ # field.

Hope this helps.

Regards,

Greg M

Thanks Greg!

The problem is: the TDCJ# is unique to that person and must remain the same. There will be multiple entries of the same person(s) listed in the sheet.

Beautiful solution. I just did not have the smarts to do it. That is why I lean on the "Gurus" to teach me. Thanks for all your help!