G
Guest
Here's the deal...I have project numbers, each project number can have
multiple subjects and each subject can multiple technologies. I have a form
running off of a query. On this form I have three combo boxes: Project
Number, Subject, and Technology. I wrote a macros for each to search for the
matching record. The Project number works fine. But the subject and the
technology boxes don't. When i chose one subject it shows me the record that
matches but also every other record that matches the project number. I don't
want it to do this...I just want to see one of the following:
1. The the matching subjects and technologies for the project number i select
2. The matching project number and technologies for the subject i select
or3. The matching project number and subjects for the technology i select.
Please help!
multiple subjects and each subject can multiple technologies. I have a form
running off of a query. On this form I have three combo boxes: Project
Number, Subject, and Technology. I wrote a macros for each to search for the
matching record. The Project number works fine. But the subject and the
technology boxes don't. When i chose one subject it shows me the record that
matches but also every other record that matches the project number. I don't
want it to do this...I just want to see one of the following:
1. The the matching subjects and technologies for the project number i select
2. The matching project number and technologies for the subject i select
or3. The matching project number and subjects for the technology i select.
Please help!