Creating eliminating result for Drop Down List in MS Access

[itikganaz]

Hi there,

I'm creating a form to store data with eliminating drop down box in MS Access 2007.

The most common example that I can see is with Address selection.
I've created a table called Address_List.
Inside the table I have fields for Country, State, City and Street (in one table).
Country State City
USA Colorado Denver
USA Texas Dallas
USA Texas Austin
USA Texas Houston

My aim was to get a drop-down list which selects the Country first, then once we've selected the country, we can select the State that's applicable for the Country.
Same goes for the City and Street selections.

Example:
First Dropdown:Select-"USA"
Second Dropdown:Select-"Texas"
Third Dropdown:Select-"Austin"

Something like that. Can it all be done using one table?
What's the easiest way to make it happen.

Thanks!

[NeoPa]

Check out Example Filtering on a Form.