By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,275 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Creating eliminating result for Drop Down List in MS Access

P: 1
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!
May 13 '10 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
Check out Example Filtering on a Form.
May 13 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.