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