Thanks, Steve. Let me clarify to make sure. I have one field for clerk,
door, clean-up, and charge ( a total of 4 fields) that I want to share the
same list (my list of employees). So if I choose an employee for field one
(clerk), when I go to field two - door, that employee's name won't appear on
the list any longer? Wow? I looked up combobox in my access book and it
doesn't tell me how to remove that employee from the row source...this is
great news if I can really do this, but can you explain a little bit more?
Is there an option on combobox that I choose to make this happen?

Thanks, Buddy

"Steve" wrote:

You need to use a form for choosing employees and their positions. On your
form use a combobox to select an employee and setup the combobox so that
when an employee us selected and assigned a position, that employee is
removed from the rowsource of the combobox.

Steve



"Thanks, Buddy" Thanks, wrote in message
...
I'm using the newest version of ACCESS. I have a (table) list of
employees.
I have a form with 4 positions (clerk, door, clean-up, charge) that I want
to
schedule using the same list of employees. How do I use this same list so
that if I choose an employee for clerk, that when I fill in the employee
for
door - that employee can not be chosen again (i.e. I want to avoid the
error
of scheduling the same employee for two or more positions).

Thanks! hope that made sense.


.