I have two check boxes(cboBranch_name & cboBranch_City) cboBranch_name displays the correct information. cboBranch_City is supposed to filter it's list depending on what selection you make in cboBranch_Name. But instead it opens a dialog box asking for input. I have entered the following code in the Row Source:
SELECT DISTINCTROW Branch.Branch_City FROM Branch WHERE (((cboBranch.Name)=Forms!MainForm!cboBranch_Name)) ORDER BY Branch.Branch_City;
Anyhelp provided would be great
Thanks
SELECT DISTINCTROW Branch.Branch_City FROM Branch WHERE (((cboBranch.Name)=Forms!MainForm!cboBranch_Name)) ORDER BY Branch.Branch_City;
Anyhelp provided would be great
