DEPENDANT LISTS (URGENT PLEASE)

[FARAZ QURESHI]

I am quite new to the world of ACCESS. I am preparing a database of
Suppliers. I have two tables INFO & LOCATION. The info form includes a number
of fields with respect to the basic information of the supplier and the
location form consists records of Area, City & Country. Example of such
records are:

Area City Country
Area1 City1 Country1
Area2 City1 Country1
Area3 City2 Country1
Area4 City2 Country1
Area5 City3 Country2
Area6 City3 Country2
Area7 City4 Country2
Area8 City4 Country2

I want the main data entry form to be showing the location's three fields
like:

Upon selection of the Country field a list should open showing the UNIQUE
names from the location table i.e.:

Country1
Country2

Then upon selecting the City area UNIQUE names of cities should be showing
in a list i.e. if Country1 is selected:

City1
City2

Finally the Area field shows the names falling in such a City i.e. if City1
is selected:

Area1
Area2

The lists should also be showing the options in an alphabetically ascending
form no matter how the areas have been entered in the table.

How can I devise such combo boxes.

Thanx in advance