Buddy,

See Bruce's reply he gives you a way to do what you want... for FREE.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

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


.



.