Filter by Form w/subforms

[tabran via AccessMonster.com]

Hi all,

I have a contact record form with several subforms accessible through tabs.
These subforms automatically display records from child tables that match the
parent table's contactID. My question is: Is there a way to create searches
for matching records, using the Filter By Form feature, using critera across
the main and subforms?

I essentially would like to be able to, for example: Search for and browse
contacts in the state 'CA' from the parent table that also have a value, lets
say 'ITEM1', listed as a purchased product in a subform that is based on
entries in a linked table. (I hope that makes sense)

I tried doing this as is with my current form to no avail. Any suggestions
or guidance would be greatly appreciated.

Many thanks,
TA

 

[Allen Browne]

Filter By Form cannot do that, but see
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

The article explains how to effectively filter a main form by changing its
RecordSource to an inner join query that limits it to a value in the related
table.

An alternative technique (useful where you are filtering across multiple
related tables) is to use subqueries in the Filter of the form (or the WHERE
clause of its RecordSource.) If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066