Hello again, I'm sure many of you have helped me already, but I'm asking for your help again. Okay, I have two synchronized combo boxes on a form. When you choose something from the first one "cboDisease" a query runs and displays in the second combo box "cboSubDisease", all the subdiseases that fall under that main Disease category. Now it is also set up that if you do not choose a main Disease from cboDisease that you can just click on the cboSubDisease field and it will display a list of all the subdiseases regardless of their main disease. What I would like to happen is if someone chooses a subdisease before the main disease, a query would run which would then work the opposite of the first way and display the related main diseases in cboDisease. Does anybody have any ideas on how to accomplish this?
Your help is greatly appreciated!
Your help is greatly appreciated!
