Set the value of dropdown list based on a listbox selection

[Asma]

Hi,

I have a listbox for countries and dropdown list for regions. I want to set the region based on the country selection.



eg. If China is slected from listbox i want region to be set to Asia automatically. I'm using Microsoft visual basic.

plzzzzzzzzz help
any idea's

[NTC]

In Access there is more than one way to solve it. One approach is to have a 2 column city table so that the region value is in the column next to the city value. One needs this fundamentally no matter how you solve the problem. Thus when one selects city, they are also defacto selecting the region. To make the region value display - make an unbound textbox with a value something like this:
=me.citycombobox.column(2)

You can control the visibility of the region value in the city combobox choice by manipulating the width of its column to either make it visible or not visible inside the city selection itself.

if you want that region value bound - instead of using an unbound text box to display it; instead - use a bit of vb in the AfterUpdate event of the city combobox to push it into a bound text box i.e. me.BoundTextBox=me.citycombobox.column(2)

hope this helps.

[Asma]

Thanks NTC

I did it using Select statement