Query to produce results filted by current record on form

[June7]

The name of the combobox is not YPMatchSearch, that's just what is on the label, the combobox name is Combo133. The combobox bound column is 1, the YPID field.

This seems to work:
SELECT OrganizationsT.OrgName, YPsT.YPLookupName
FROM OrganizationsT, YPsT
WHERE YPsT.YPID=[forms]![MatchSelectedYPF]![Combo133] AND
((OrganizationsT.[OrgArtsCulture]=True And [YPsT].[YPArtsCulture]=True)
Or (OrganizationsT.[OrgEnvironmental]=True And [YPsT].[YPEnvironmental]=True)
Or (OrganizationsT.[OrgHealthcare]=True And [YPsT].[YPHealthcare]=True)
Or (OrganizationsT.[OrgYouthMentorship]=True And [YPsT].[YPYouthMentorship]=True)
Or (OrganizationsT.[OrgPovertyBasicNeeds]=True And [YPsT].[YPPovertyBasicNeeds]=True)
Or (OrganizationsT.[OrgSportsAthletics]=True And [YPsT].[YPSportsAthletics]=True)
Or (OrganizationsT.[OrgIntlDiversity]=True And [YPsT].[YPIntlDiversity]=True)


Or (OrganizationsT.[OrgBusiness]=True And [YPsT].[YPBusiness]=True));

Delete the duplicate record #4 for Samantha.

[kelann]

Argh! I had changed it! Good grief. Thank you very, very much for looking at the database and providing the correct language -- I appreciate it!!

[kelann]

Julie, you are so fabulous! Thank you so much! It works perfectly!!!!!!!