Find records in a Subform

[John Milward]

Hi

I have a form which contains Customer information and a subform which shows
all the contact names at that address.

I need to be able to do a 'Find' for a name and show the Customer record(s)
that contain that name.

Any ideas please?

TIA

John

 

[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 for so it contains
only records that have a match in the subform by assigning an INNER JOIN
statement to its RecordSource.

Another alternative is to use a subquery in the form's Filter.