How to Populate One ListBox Based On Another ListBox

I

irisbutnaru1

Hello everybody!

I have created a UserForm with 2 listboxes (comboboxes). The data for
those combo's is from an Access Database ( a table with 2 coloms).


I work with WORD/Access XP.


colomn 1: countries
colomn 2: cities


for example:
USA NewYork
France Paris
USA Washington


I need a macro that will enable me to choose a value in combobox 1
(for example: USA) and in combobox 2 I will get only the cities of
USA
(for example: New-York, Washington... end so on).


I will be very grateful for your HELP!!


Iris
 
Top