Find records in a Subform

  • Thread starter Thread starter John Milward
  • Start date Start date
J

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
 
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.
 
Back
Top