Combo Box on Datasheet View Form

[James Stephens]

Here is what I have gotten worked out and need some help. I have a form with
a subform. That subform is viewed as a Datasheet. It is tied to a query
that gets data from several tables to return four things: Name, SSN,
Position, ReportsToPosition.

The idea of this is to be able to select direct reports for employees. The
ReportsToPosition is the job classification of those who could be the direct
report of the employee, ie. Employee --> Supervisor, Supervisor -->
Manager. This makes my data look like this.

Emp SSN Position ReportsToPosition ComboBox
John 111-11-1111 Employee Supervisor
Jane 222-22-2222 Employee Supervisor
Rob 333-33-3333 Employee Supervisor
Fred 444-44-4444 Supervisor Manager

What I need to do is set up a combo box that will be a list of all those
people who have a job classification that is equal to that in the
"ReportsToPosition" column. Everything I have tried will not work, the best
I get is a list for only the first record, and the list remains the same for
all records. If you select something, it selects it for all records. I need
the Names populated in the combo box to be different for each of the people,
based on the ReportsToPosition value for each record.

I need help !!!!!!

Thanks,

James Stephens