Resolving Values on a Combo Box

[Mattine]

I have a combo box that contains an employee id, is there any way that when I choose one employee id that all the tasks assigned to them will show up and only the tasks assigned to them?

This is for a database that contains employee tasks.

Thank-you for your help!

 

[Maquis]

I believe the simplest way to accomplish this would be to add a sub-form containing the employee tasks to your form.

Set the master link field to be the name of the combo box and the child link field to the employee id.

Good Luck.

 

[Mattine]

Dear Maquis,

What would be the syntax for that?

Sincerely,

~Mattine