fill combobox selection based on a selection from the first combobox

Hi,

I have a client database sorted into columns which are named defined i.e Companyname, Firstname, Lastname, Mobile, Email, etc

I have created a user form for the operator to enter in a search for company name and from this search a list of the corresponding employees will appear. From this list, I wish the operator to than be able to select the relevant employee and then all thier details will appear (mobile, address, email, position etc)

I have created a combobox which enables you to type in the company name and it auto spells out and shows list, from there I need the next combo box to show relatiive employee.

Thanks

Thank you so much for your amazing assistance and prompt reply, your answer works perfectly! genuis