Bad Code For Combo Boxes

Ringers

Registered User.
Local time
Today, 15:32
Joined
Mar 4, 2003
Messages
54
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.:D
 

Users who are viewing this thread

Back
Top Bottom