Populate a ComboBox

[purplegerbil]

Hi,

I have filled a combo box from an access db. Depending on what the user selects I want to fill another combo box with the results.

ie

Combo 1 contains Counties. If the user selects say Yorkshire, all the town in that county appear in the second combo box so the user can select one. The counties and towns are stored in the same db.

County
Town
County_ID

I am sure this is possible but not sure how. vbScript if possible. not done too much javascript.

Any help would be greatly appreciated..


Cheers
PurpleGerbil

[MikeSA]

Hi,

I have filled a combo box from an access db. Depending on what the user selects I want to fill another combo box with the results.

ie

Combo 1 contains Counties. If the user selects say Yorkshire, all the town in that county appear in the second combo box so the user can select one. The counties and towns are stored in the same db.

County
Town
County_ID

I am sure this is possible but not sure how. vbScript if possible. not done too much javascript.

Any help would be greatly appreciated..


Cheers
PurpleGerbil

I have the same problem. Looking forward to a reply from someone who knows...
MikeSA

[Ranjan kumar Barik]

I have the same problem. Looking forward to a reply from someone who knows...
MikeSA

Hi
You can just keep the selected item, from combo1, in a variable say "var1" and using that you can write a query to retrieve the towns column only where the "country = var1", that is the selected country, and just fill the combo box 2.

You just can do it in vbscript.
Hope the idea will work.

[jhardman]

I have the same problem. Looking forward to a reply from someone who knows...
MikeSA

There are two ways to do this that I have seen on the web. One way is to have a whole bunch of drop down selects (they are called "selects" in HTML) already made but hidden on the page, so that when the user makes the selection in the first select, the second just has to appear. Does that make sense? This is done with javascript or dynamic css and isn't that difficult if you know what you are doing.

The other option is to submit the form when a selection is made, then resend the exact same form to the user (with the previously filled out inputs already filled out) with one more dropdown select. This method is easier if you don't want to mess with javascript and you don't mind that the form will freeze up for a second while the page reloads. Does this make sense?

Either way works, and your choice should be largely dependent on which are you more comfortable with coding.

Jared