SUBFORMS HELP PLEASE!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a access database to monitor my departments training needs. We
have a number of roles each which require specific training. I want to creat
a subform in my main form which shows the training required by each role when
the role is chosen on a drop down menu on the main form. I have created a
table with the four roles and the 'Role:' field in the main form is linked to
that. Then i have created a table with each of the four roles and the
training required by each role e.g.
role training required

ROLE 1 Training 1
ROLE 1 Training 2
ROLE 1 Training 5
ROLE 2 Training 1
ROLE 2 Training 7
ROLE 2 Training 9
ROLE 3 Training 2
ROLE 3 Training 8
ROLE 3 Training 6

Can anyone help on how to make this subform please?? Thanks in advance, Hem
 
Sounds like you are on your way. Just create a subform off the training
table. Place that on your main form and make the Child and Master link
properties to be Role. When you pick a different role on your main form, it
will change the data on the subform to just reflect that role.

Hope this helps. Let us know if you need more specifics.
 
Back
Top