[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

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.
0
mrong
Asked:
mrong
  • 2
1 Solution
 
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now