Using a Combobox to control a Subform

[accessuser10]

Hi all,



I currently have a form with a combobox that I want to use to control a subform that I have inserted. Both the parent form and the subform are pulling data from a different table. From the combobox, I want the user to be able to choose a persons name, and then the subform will display each project that the person has worked on based on the name that has been chosen. The reason that I have a subform is so that the user is able to click through projects that pertain to a certain employee. I have the master fields and child fields linked on the employees name as there are not to many employees and the names are all unique.

Does anyone have any suggestions on getting this to work?

Thanks

[RuralGuy]

Are you using the ComboBox on the MainForm to locate a record on the MainForm? If not, why not?

[accessuser10]

Maybe I could do it without a subform, I want a combobox that shows all employees names, and then another combobox that is dependent on the employee name that shows only the projects that the employee worked on. I have textboxes that are linked to the same table that allow the user to enter ratings based on the employee and the project.

[RuralGuy]

Maybe you could use two SubForms.