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