Combo box to fill text boxes (1 Viewer)

[dark11984]

Thanks everyone for their help so far!
I have a combo box on my form to select the employee's name and then i have multiple text boxes on the form that i want to automatically fill with the selected employees details (i.e phone number, fax, etc) which are located in another table called [employees]. How do i do this?

Also I have other information on the form such as product data, should i have employees details and products all going back to the one table or should there be a subform for the employees details?

 

[georgedwilkinson]

Main form: employees

Subform: employee detail stuff

Combo-box: unbound on the main form. Use the combo-box wizard and select the 3rd option.

How is product data related to employees? If you're talking about product sales data, you would use a subform based on a query.

 

[Luddite Lad]

Do mean the sort of thing I've done in this sample?