Dynamically Linked multi-Selection Box in Access

Greeting,

I want to create 3 dynamically linked multi-selection box on an Access 2007 form like the following.

I have 3 columns in the table with data in there: State,City,city Name

Below is what I want.

On the form, If the users select in state listbox(can be multiple), the associated cities(can be multiple) will show up in the city listbox, also the matching city names will show in city Name listbox.

Please provide sample if possible.

Thanks.
mrongAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
0
Jeffrey CoachmanMIS LiasonCommented:
Note that most of these links involve "Combo boxes", not Multi-select Listboxes.
Multiselect Listboxes, present their own set of complexities...

In many cases it may be simpler to just use Forms and subforms...
0
Helen FeddemaCommented:
Here is a basic description of linked combo boxes; it could also be used for single-select listboxes:

cboSelectCustomer has tblCustomers as its row source.  Its AfterUpdate event sets cboSelectOrder to Null or "", and requeries cboSelectOrder.
cboSelectOrder has tblOrders as its row source, with a criterion of [Forms]![frmSelectOrder]![cboSelectCustomer]

However, with multi-select listboxes the problem is much more complex.  My Access Archon article on Filtering by Multiple Selections might be useful:

http://www.helenfeddema.com/Files/accarch197.zip

Here is a screen shot of the form, showing multiple state selections used to filter a subform:

Filtering by Multiple Selections in Listbox
You would need to use the multiple selections in a listbox to filter the row source for the next listbox in the cascade.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.