This is my first post so I hope someone understands my problem
I have an excel worksheet which lists employees names, dob and employee numbers

A B C D
1 EmployID FName GName DOB
2 123456 Jones James 19/02/1976
3 345678 Smith Roger 04/05/1955
4 678901 Evans Jon 16/11/1964

My report is a word document (2010) which uses a userform to collect information from the spread sheet and then pass the data to bookmarks (legacy form fields) in the document.
On my frmEmployee userform I have a combo box (cboID) which is linked to the excel spread sheet when I initialize the form and I can select the employee’s ID number. How do I then pass the other information ie FamilyName, GivenName & DOB to text boxes on the same form (txtFName, txtGName & txtDOB).


Thanking you in advance