Filtering on main form and subform

  • Thread starter Thread starter Darrell
  • Start date Start date
D

Darrell

I have a problem I have repeatedly encountered. If I am
viewing data on a main form with data on a subform, how
do I accomplish a find when part of the data I want to
include in the criteria is on the subform?

Thanks.
 
See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

The article explains how to change the RecordSource of the main form so it
only shows records that have a match in the subform, and combine that
technique with a Filter on the main form's fields as well.
 
Thanks Allen. I'll check that out.
-----Original Message-----
See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

The article explains how to change the RecordSource of the main form so it
only shows records that have a match in the subform, and combine that
technique with a Filter on the main form's fields as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Back
Top