Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-13-2019, 10:47 PM   #1
Ahmad_3011
Newly Registered User
 
Join Date: Jun 2013
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Ahmad_3011 is on a distinguished road
Multivalue listbox filter

I have a form called Clients that contains two multivalue listbox I can chose from the city list more than one city I need to show the districts on the other city that matches with the selected cities.
Attached Files
File Type: accdb test.accdb (700.0 KB, 18 views)

Ahmad_3011 is offline   Reply With Quote
Old 03-13-2019, 11:13 PM   #2
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,464
Thanks: 0
Thanked 573 Times in 569 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Multivalue listbox filter

I have never seen cascading comboboxes attempted with multi-value fields.

Why is CityID in Areas a multi-value field? So a city has multiple areas?

Appears to be a circular relationship with the 3 tables.

Saving City into Clients doesn't make sense because there are multiple records in Areas for same city. Save the area and then city can be found via query through the area.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 03-13-2019, 11:29 PM   #3
Ahmad_3011
Newly Registered User
 
Join Date: Jun 2013
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Ahmad_3011 is on a distinguished road
Re: Multivalue listbox filter

Hi June7, thank you for your quick response, actually it's a sample for a bigger project, I just submitted an example, but in the real world I have clients that has offices in more than districts in many cities.

Ahmad_3011 is offline   Reply With Quote
Old 03-14-2019, 12:51 AM   #4
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,289
Thanks: 115
Thanked 3,090 Times in 2,808 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Multivalue listbox filter

This structure is going to make your database almost unusable in the real world.
1. Using table level lookups is a bad idea. See http://access.mvps.org/Access/lookupfields.htm
2. Multivalue fields make it very difficult to query and trying to use them to filter other fields would be a nightmare in my opinion. See http://www.mendipdatasystems.co.uk/m...lds/4594468763
3. Relationships are based on the MVFs and in a loop. I'm fairly sure you will end up with read only queries.

Recommend you review your data structure to fix the above issues

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)

Last edited by isladogs; 03-14-2019 at 01:06 AM.
isladogs is offline   Reply With Quote
Reply

Tags
filter , multivalue fields

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find/Compare/Select from Textbox to Multivalue Listbox *Unselected* 123noob Modules & VBA 1 06-17-2017 01:09 AM
Using multivalue listbox to filter records via another multivalue field WJB General 4 01-25-2017 09:52 AM
Using Or Statement from Multivalue Listbox in Query Randomguy Queries 12 07-12-2013 11:36 AM
Multivalue listbox on from to a query/report kc5589 Forms 0 09-26-2011 10:17 AM
Listbox simalar to Multivalue Selection vapid2323 Forms 0 03-23-2011 10:26 AM




All times are GMT -8. The time now is 05:23 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World