Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search both main and subform with search form

Status
Not open for further replies.

HBT

Technical User
Jun 6, 2000
4
0
0
US
OK. I have searched and searched and I cannot seem to decipher any of the available threads to provide an applicable answer.

I have a main form called DonorInfo which displays donor information. There is a subform that displays Business information. The forms are linked via donor ID. I also have a search form that displays a few DonorInfo combo box fields from which a user selects, then clicks a Search button which uses the terms to search/filter the DonorInfo main form. The coresponding Business subform is also displayed. Is there any way to include one of the Business subform fields as a search term so that the user can run a search across the main DonorInfo form AND Business subform?

Please help!

HBT
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top