Userform selection yields wrong information

[darbar76528]

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