Solved

Dynamically Linked multi-Selection Box in Access

Posted on 2012-04-12
4
310 Views
Last Modified: 2012-05-08
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.
0
Comment
Question by:mrong
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Expert Comment

by:als315
ID: 37837671
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37837862
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37837878
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
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 total points
ID: 37838719
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question