Searching Subforms Using the Filter By Form Menu Function

D

David L.

Is it possible to use the Filter by Form function to search for information
contained within subforms?

I have three tables:

tblpubcompany
tblcontact
tblcontactdetail.

These tables, moving from top to bottom, have a one-to-many relationship to
one another.

I needed to add a calculation fields to the tblpubcompany table which I did
by creating a query named qrypubcompany.

I proceeded to use the Wizard Form tool to build a Form containing a Main
Form and two Subforms. The main form fields came from the qrypubcompany Query
and the Subform field came from tblcontact and tblcontactdetail.

After designing the forms and subforms I attempted to use the Filter By
Form function to find records based on fields contained within the Main Form.
I had no problem finding matching records.

However when I try to find records based on fields contained within the
subforms nothing happens. Access basically returns all the records in the
database because all the fields on the Main Form are empty (no search
criteria).

I also want to all be able to search the Subforms and Main Form together not
sure how I would need to go about doing that.

Thanks,

David L.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top