Trying to populate fields on a form from a combo box... Zero VBA skill

[Oscar.Ingalls]

I'll start off saying that I am getting a VBA book, but for expediency I need a simple solution or a stoopid proof walk thru. I know just enough to get myself into trouble... and know that I am WAY over my head.



Training database, tblemployees, tbltasks, tbltaskstoemployees. Apend qry (qrytaskstoemployees) makes a record for each employee where the task and the employee have the same workcenter, or all in the case of generic training tasks.

frmtrainingupdate is a subform showing all records from tbltaskstoemployees for the employee record currently selected on the parent form. Trying to select employee to update via combo box that derives names from tblemployees, then populate subform with the list of tasks for the employee that was selected in the combo box. tblemployees and tbltaskstoemployees share ID key but not 1 to 1 as tbltaskstoemployees has multiple records per employee based on how ever many training tasks are assigned to them.

Happy New Year... and thank you for any assistance.

Oscar

[June7]

What do you mean by 'training tasks are assigned to them'. Where are the training tasks selected? If you want to provide db for analysis, follow instructions at bottom of my post.

[Missinglinq]

If I understand you correctly, you already have your Main Form/Subform set up, and only need a Combobox to retrieve a Record in the Main Form, along with the related Subform Records. If this is correct, Add a Combobox to your Form’s Header, and when the Combobox Wizard pops up, select "Find a record based on the value I selected in my combobox," then follow the Wizard's instructions as you go down the Yellowbrick Road!

When you make a selection from the Combobox, the appropriate Main Form Record should appear, along with the related Records in the Subform.

Linq ;0)>