Combo box not populating subform

[MsDYJ]

Greetings All!

I have a couple of questions about a combo box I'm using on a subform. I
have a table that lists all the possible Project Managers that can be
assigned to any projects. Essentially, what I want to happen is that on the
subform the user can select from a drop down menu and select the manager, and
all of there associated information auto populates. I've created a query
that has concatenated the PM first name and last name fields to make a full
name. My issues are:

1.) After I've created the combo box and select a name, the information does
not automatically populate, and
2.)Once I can get the combo box to work, how do I keep my project manager
table from showing duplicate values if a PM is on more than 1 project. Should
I create a "project detail" table that stores information for each project?

Thank you kindly,
Ms.DYJ

 

[Kipp Woodard]

If the purpose of the value of combo is to associate the record(s) of the
subform with the main form, then the combo should be on the main form. If
you link the subform to the main form based on the value of the combo on the
main form, then when you select a value from the combo any related records
will appear on the subform. The combo box would need to be bound to a column
of the table that the main form is bound to.