combo box - filter for records matching subform child field

  • Thread starter Thread starter lisa
  • Start date Start date
L

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
 
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
 
Back
Top