Subform Options

H

hrassistant

I have a form that links an "employee group" to a sub form for each position
that belongs in that particular "employee group".

[Main Form]
ALL EMPLOYEES [Group]

[Sub Form]
Hr Manager [Position]
GM [Position]
Etc.
Etc.

What I want to do (for ease of input) is show ALL positions (coming from my
positions table) that are active, and have a check box next to each. This
would make it easy for the user to view all positions available and positions
selected. Right now I have a drop down menu and it is difficult to tell what
has NOT been selected without manual reviewing the list of positions and
knowing who is missing.
 
H

hrassistant

In the alternative, is there a way to not show records already selected for
that group?

So the dropdown menu would not show any position that has already been linked
to that employee group?

This would actually help me in some other areas as well throughout my
database.
 
Top