Cascading Combo Boxes

[Anil Bagga]

I created a table with Country, State and City . In the form I select country, state and then city. I am able to select the state easily after selecting country. Using the same logic, I am unable to select the city from the same table matching the value of state. I have gone through the data over last 2 / 3 days, created a new form but still having issues. The screenshots enclosed will explain my problem. I used the same logic for State and City but why City is not showing in drop down is a mystery

Need HELP.

[ranman256]

the query for combo3 (city) should look at city:
select city from table where [state] = forms!fMyForm!cboState

BUT everytime user picks a cboState, you must refresh cboCity:

sub cboState_Afterupdate()
  cboCity.requery
end sub

[Anil Bagga]

I created a table with Country, State and City . In the form I select country, state and then city. I am able to select the state easily after selecting country. Using the same logic, I am unable to select the city from the same table matching the value of state. I have gone through the data over last 2 / 3 days, created a new form but still having issues. The screenshots enclosed will explain my problem. I used the same logic for State and City but why City is not showing in drop down is a mystery

Need HELP.

I have Requery in the configuration

I think we need to look at ALL the Cities of states in the table where the states = cboState of the form. Therefore the code below seems to be correct. The code is copy pasted from the Row source file populated from query builder

SELECT CountryStateMaster.[CustCity], CountryStateMaster.State FROM CountryStateMaster WHERE (((CountryStateMaster.State)=[Forms]![CustMasterFrm]![State]));

I am unable to upload the database file due to size restrictions

[CarlettoFed]

You must first compress it through a file compression program such as Winzip or Winrar.

[Anil Bagga]

I have Requery in the configuration

I think we need to look at ALL the Cities of states in the table where the states = cboState of the form. Therefore the code below seems to be correct. The code is copy pasted from the Row source file populated from query builder

SELECT CountryStateMaster.[CustCity], CountryStateMaster.State FROM CountryStateMaster WHERE (((CountryStateMaster.State)=[Forms]![CustMasterFrm]![State]));

I am unable to upload the database file due to size restrictions

I am enclosing the database file, after compressionCascadeComboTest.accdb.zip

[Bob Fitz]

Change the Bound Column property of the "State" combo box from 3 to 1

[Anil Bagga]

Perfect. Thanks. This worked!! What is the logic? Will appreciate an response for a better understanding. The "State" is in Column 0 and is showing either way!

[Bob Fitz]

Perfect. Thanks. This worked!! What is the logic? Will appreciate an response for a better understanding. The "State" is in Column 0 and is showing either way!

Technical explanations are not my strong point but as you've asked I'll do my best to explain my understanding. Other members might do it better. I'm sure you'll find lots with google.

The bound column property dictates which piece of data is saved in the forms Record Source (Table/Query) in the field used as the controls Control Source property. With the Bound Column setting of "3" you were actually saving the "State Code" so the criteria used in the Row Source property of the "CusCity" combo was returning records where the state was the same as the State Code ("GJ" for example). Of course no records match so the "CusCity" combo was always empty.

I hope this helps. Post back if you have further questions.