I am attempting to Synchronize two combo boxes.
I have managed to get the first combo box to produce the right Branch Names. But the Second Combo box is empty and i don't know why.
The Two combo boxes are supposed to filter branch names and citys from the same table(Branch).
The row source code is as follows:
SELECT DISTINCTROW Branch.Branch_Id, Branch.Branch_City FROM Branch WHERE (((Branch.Branch_Id)=Forms!MainForm!cboBranch_City)) ORDER BY Branch.Branch_City;
If somebody can provide assistance with this it would be great, Thanks.
I have managed to get the first combo box to produce the right Branch Names. But the Second Combo box is empty and i don't know why.
The Two combo boxes are supposed to filter branch names and citys from the same table(Branch).
The row source code is as follows:
SELECT DISTINCTROW Branch.Branch_Id, Branch.Branch_City FROM Branch WHERE (((Branch.Branch_Id)=Forms!MainForm!cboBranch_City)) ORDER BY Branch.Branch_City;
If somebody can provide assistance with this it would be great, Thanks.
