Filter Parent Form Based on Child Form Criteria

[Guest]

I have a parent form with customer information. The primary key is the
CustomerID field.

There is a subform linked to the customer using the CustomerID field. The
subform contains phone numbers (a seperate record for each phone number).

How can I filter the parent form with criteria from the child form (phone
numbers). For example, I want to find each customer who is in the 413 area
code.

Any help would be GREATLY appreciated.

 

[ruralguy via AccessMonster.com]

Maybe MVP Allen Browne's suggestion will work for you.
Filter a Form on a Field in a Subform
http://allenbrowne.com/ser-28.html

 

[doodle]

in the query that you are using as the source for your subform, build a
field that pulls the area code out of the phone number. then put this
in the criteria for that field:

[Forms]![myMainForm].[AreaCodeFieldFromMainForm]

-doodle