Filtering on main form and subform

[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.

 

[Allen Browne]

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.

 

[darrell]

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.




.