change a combobox value depending on another

[emadaldin]

hey guys ,
i'm new to access so don't laugh on my problem.
hope u can help me with it.

simplified:
table 1 name : city
first column : cityid (number) and it's the primary key


second column : cityname (Text)
and fields on it US, UK, JP

table 2 name : area
first column : areaid (number ) and it's the primary key
second column : area name (Text)
and fields on it > California, London, Tokyo


i made a forum with 2 combo boxes first is ( city ) and second is ( area )

what i need is : when i choose US from the first combo box
it shows only California in the second combobox
and when i choose UK it shows only london
and so on ..
i'll upload my file . hope u guys help a newbie here .




--- edit --- just a thought . made an cityid column in the area table and used query to link it ... but still it shows only 1 specific area for all the city i have .....

[jzwp11]

Welcome to the forum!

Shouldn't your first table be countries not cities?

tblCountry
-pkCountryID primary key, autonumber
-txtCountryName

I also assume that US, UK and JP are records in the table not fields.

tblArea
-pkAreaID primary key, autonumber
-fkCountryID foreign key to tblCountry
-txtAreaName

Again I assume that California, London, Tokyo are records in the area table.

Regarding your form, you are describing a concept known as cascading combo boxes where the choice in the first combo box filters what the user sees in the second combo box. There are many examples of this on the web. Here is a link to one such site that has an example database that should help.

[emadaldin]

Well , u just understand what i want and Gave me the best example i needed
Thanks Very much now it's working perfect .

[jzwp11]

You are welcome! Glad to help out.