I have one combobox in which you select an option. What is the sql used in the query to restrict the second combobox depending on the first value. All I seem able to get is:
[SELECT Name_Of_Race FROM Races WHERE
Name_Of_Allegiance = DBLookupComboBox1.Value]
Here, when I press the button to set the first combobox as the selected value, the second one appears but with no values in it. I have replaced DBLookupCombobox1.Value with a correct value and the second combobox behaved as expected, so I can only presume I am using an incorrect identifier. If anyone could help it would be much appreciated. Thanks ! :)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!