search feature with subforms

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.

See:
Filter a Form on a Field in a Subform
at:
http://members.iinet.net.au/~allenbrowne/ser-28.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ashley" wrote in message
...
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.