Asking for input

Ringers

Registered User.
Local time
Today, 15:32
Joined
Mar 4, 2003
Messages
54
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:D Thanks
 
I had this problem and am still looking for an answer but can I make a gues that these combos are on a subform?
 
No their on the main form and are supposed to update the subform. Which doesn't work either :)
 

Users who are viewing this thread

Back
Top Bottom