searching subforms

[David L.]

Is it possible to use the "Filter By Form" function to search for data within
subform fields? I have not had any success using this function.

I created three tables. tblmarkets, tblcontacts and tblcontactdetails. I
created a one-to-many relationship between these three tables. Using the Form
Wizard I created a form. tblmarkets is the main form and tblcontacts and
tblcontactdetails are the two subforms. I tried using the "Filter By Form"
search feature in the subforms but nothing happens. The "Filter By Form"
function works in the main form. I'm I doing something wrong? Is my
understanding of this search function incorrect?

Thanks for your help,

David

 

[Allen Browne]

No. The Filter By Form can only find records that are loaded. Since the
subform contains only those records that relate to the record in the main
form, Filter By Form is not able to find other records that are not
currently in the subform.

However, it is possible to filter the main form so that it contains only
those records that have a match in the subform. If that is what you are
seeking to do, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html