Updating combo box value based on another combo box value

[gaurav2310]

Hi All,
I have a table in which I have following fields:-

1. Region
2. Country
3. VendorName

I want to create a form which will filter the data based on selection in previous form. (I dont want user to make any changes on the form i.e. Add,Edit or Delete) Hence i have kept all the fields on the form as "unbound".

In my form I have CboRegion , CboCountry

For CboRegion i have created a select query which will filter data and shows me unique value. This part is working absolutely fine.

For CboCountry i have created parameter query based on selection made by user in CboRegion. The query name is QrySelectCountry which is showing under Row Source property.

When i run the form and i select item in CboRegion the data in CboCountry is popping up correctly, but when i change the value in CboRegion the data is not updating in CboCountry. (If i hit F5 it is working fine but not updating automatically).

I tried afterupdate and change event of CboRegion by putting Me.Cbocountry.Requery or DoCmd.OpenQuery "QrySelectCountry" but still the data in CBoCountry is not updating.



Could you please help me on what I am missing or what needs to be done so that my fields will pop up data automatically.

Thanks & Regards,
Gaurav

[ItsMe]

Perhaps you can add code in the On After Update event of CboCountry that will Requery the CboCountry combo.

[orange]

Country/Region/State etc is often handled with cascading comboboxes.
Here is a free video tutorial (Access 2003 or so) that has the details of creating Cascading Comboboxes.

Other info re comboboxes.

Good luck with your project.

[gaurav2310]

Thanks Itsme and Orange.

The video just works fine for me.

Regards,
Gaurav

[orange]

ItsMe and I were happy to help.
Good luck with your project.