Prev: Search on one field & fill in the correct matching record
Next: Filtered Form
From: Thanks, Buddy Thanks, on 5 Dec 2009 15:06
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.
From: Steve on 5 Dec 2009 16:04
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
santus(a)penn.com


"Thanks, Buddy" <Thanks, Buddy(a)discussions.microsoft.com> wrote in message
news:A06C8902-024D-499A-9F90-2DBFD47E20A7(a)microsoft.com...
> 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.


 | 
Pages: 1
Prev: Search on one field & fill in the correct matching record
Next: Filtered Form