combo box - filter for records matching subform child field

[lisa]

I have a combo box (contact person) in a subform that I
want to use only to select records that match the
Master/Child link in the subform (EmployerGroupID).
Currently the cbo picks up all contact people from all
Employer Groups. How do I filter to only pick up contacts
from the specific employer group?

Thanks in advance

Lisa

 

[Allen Browne]

You want to filter the main form so it contains only those employer groups
that a particular contact person belongs to, and the contact person is in
the subform.

The trick is to change the RecordSource of the main form to an inner join
statement which effectively filters it. Details in article:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html