Find/Filter on a subform

[Leif]

I have a form that has numerous subforms. This form and
subforms are represented a main table and a number of
other tables related to the main table in a one to many
relationship.

I can do a find/filter on the main main table. I can also
do find/filter operations on the other tables. However,
for the subform the find/filter relates only to the
content of the that table and not the main table.

To be more specific, I have a project main form. One
subform has billing numbers in a one to many relationship.
I woud like to be able to, for example, find all project
that share a common billing number. However, when I try
to do a filter in the billing number subform only that
data is filtered, not the parent form.

Does anyone know how this may be done?

Thanks.

 

[Allen Browne]

See:
Filter a Form on a Field in a Subform
at:
http://members.iinet.net.au/~allenbrowne/ser-28.html

The article explains how to assign the RecordSource of the main form to an
inner join query, such that it contains only records that have a match in
the subform.

 

[Leif]

Thanks. Very nicely explained. I've bookmarked your site.