Dependent Drop Down lists (multiple drop down)

Hi

Can't see the screen shot, but perhaps you could attach a sample file that has data to match what you are trying to do. Include the code you have given, and give a scenario - say if you pick xxx from combobox1, then you would see yyy,zzzz,aaa in combobox2......


rylo

Hi Rilo,

I am attaching the screen shot. I have 4 drop downs. To illustrate, if I select Fruit in drop down and Apple in drop down 2, I should only have two items in dropdown 3 (Golden & Natural), once I select one from dropdown 3, I should only have "Ontario" as available option in dropdown 4.

This is what I want to achieve.

Hope you can help.

Thanks

Jijy

Hi

See if the attached file gets you started.

rylo

Hi Rylo,

Thanks a lot for your help. Really appreciate the time & effort you took to help out.

I am going to modify this a little bit and will come back to you if I have questions.

Thanks once again.

Jijy