A
ashley
On one form which I call it the "search form". The combo
box(unbound) contains the data for the types of Training
from a table (using select statements).
On the main form, it is getting data from a table that
shows the name of people and department.
On the subform (continuous form), it shows the different
types of training these people have which is linked to the
main form.
What I am trying to do is when I select a type of Training
(ie. orientation) from the combo box on the Search form, I
want the main form to only show the people who have taken
the orientation. It is comparing the training from the
combo box on the search form and the training field in the
subform.
box(unbound) contains the data for the types of Training
from a table (using select statements).
On the main form, it is getting data from a table that
shows the name of people and department.
On the subform (continuous form), it shows the different
types of training these people have which is linked to the
main form.
What I am trying to do is when I select a type of Training
(ie. orientation) from the combo box on the Search form, I
want the main form to only show the people who have taken
the orientation. It is comparing the training from the
combo box on the search form and the training field in the
subform.