MS Access - retrieve related data based on item in dropdwn contrl

[dancattransit]

I'm trying to design a form that will do the following: When I select
"employee name" from a drop down control, I want other fields on the form to
populate with data about that employee. (i.e. address, phone #, DOB, SS#,
ect.). All data resides in the "employee" table.

 

[Duane Hookom]

You should only need/want to display the related information, not actually
populate bound fields.

You can do this quite easily by including all of the required fields in
columns of the combo box. You can then display the other columns in text
boxes with control sources like:
=cboEmployee.Column( N )
The N is a column number based on 0 as the first column and 1 as the second.