Thanks Steve. I'm beginning to think this project is above my ability, but
I'm willing to challenge myself. I just don't get how to 'make the row
source a query and then design the query to remove all employees previously
selected from the row source'. I'll play around with it. I'm also looking
for a template out there for someone else who may have run into the same
problem.

Thanks,
Buddy
"Steve" wrote:

It sounds like your tables are not correct. They should be something like:
TblEmployee
EmployeeID
FirstName
LastName
etc

TblPosition
PositionID
Position

TblSchedule
ScheduleID
ScheduleDate

TblScheduleEmployeePosition
ScheduleEmployeePositionID
ScheduleID
EmployeeID
PositionID

There is no built-in way in a combobox to remove that employee from the row
source. You need to make the row source a query and then design the query to
remove all employees previously selected from the row source.

Steve




"Thanks, Buddy" wrote in message
...
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.


.



.