Dynamically Linked multi-Selection Box in Access
Posted on 2012-04-12
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.