Filtering In Subforms

[Noel]

Hi. Im finding that its not possible to effectively filter
on a field value in a subform. Take the Northwind mdb
(Access 97 version) as an example. If I open the Orders
form and filter in the subform for the value Chartreuse
verte in the Product field, I get every Customer record
showing i.e. those who have ordered Chartreuse verte and
those who have not. Is it not possible to filter down the
main records to only those that have a specified value in
a chosen subform field? Thanks, Noel

 

[Allen Browne]

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

The article explains how to effectively filter the main form by assigning an
Inner Join statement to its RecordSource, so it displays only the records
that have a match in the subform.

 

[Noel]

Thanks Allen, Ill have a look at that. Cheers, Noel