UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Allow Multiple Value, Any Version    
 
   
access2009eg
post Feb 16 2020, 06:22 AM
Post#1



Posts: 1,172
Joined: 19-February 08



Hello Friends;

I have a 2 Combo box build on one table with allow Multiple Value

ID Province City

Can when select 2 Province I can see only there cities, not All cities

Thank you so much

--------------------
I would like to Thank you for your help
Go to the top of the page
 
DanielPineault
post Feb 16 2020, 07:19 AM
Post#2


UtterAccess VIP
Posts: 7,247
Joined: 30-June 11



This is commonly referred to as Cascading Comboboxes. Refer to https://www.UtterAccess.com/wiki/Cascading_Combo_Boxes or Google for many more samples/demos. Once you setup your first set of cascading comboboxes you'll see it truly isn't very complicated.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
access2009eg
post Feb 16 2020, 03:18 PM
Post#3



Posts: 1,172
Joined: 19-February 08



DanielPineault

Thank you so much

Please look at the attached image this is multi-value combo box
Attached File(s)
Attached File  MulitVAlue_Combobox.png ( 5.52K )Number of downloads: 1
 

--------------------
I would like to Thank you for your help
Go to the top of the page
 
projecttoday
post Feb 16 2020, 04:57 PM
Post#4


UtterAccess VIP
Posts: 11,788
Joined: 10-February 04
From: South Charleston, WV


I think it's a multi-value field in the table.

Sorry, but these are not recommended.

--------------------
Robert Crouser
Go to the top of the page
 
DanielPineault
post Feb 17 2020, 06:14 AM
Post#5


UtterAccess VIP
Posts: 7,247
Joined: 30-June 11



That is a multi-valued field and they are to be avoided. There is little you can do with them as you cannot access the hidden tables behind them. Best create your own properly normalized tables to achieve the exact same behavior with continuous forms and then you'll be able to create cascading combo boxes as you see fit.

Basically, run away from multi-valued fields, attachment filed, hyperlink fields, Lookup fields, ... they will just cause you unnecessary headaches. Even Calculated field are to be very carefully used, if at all.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
theDBguy
post Feb 17 2020, 10:54 AM
Post#6


UA Moderator
Posts: 77,715
Joined: 19-June 07
From: SunnySandyEggo


Hi. Sorry for jumping in... What you are asking is probably possible; but if you can avoid MVF and able to figure out another way to do it, you might be better off in the long run. If you're stuck with this, maybe you can post a demo version of your db, so we could try to show you how to make it work. Just a thought...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
access2009eg
post Feb 18 2020, 10:18 AM
Post#7



Posts: 1,172
Joined: 19-February 08



DB file
Attached File(s)
Attached File  Database8___Copy.zip ( 43.34K )Number of downloads: 3
 

--------------------
I would like to Thank you for your help
Go to the top of the page
 
projecttoday
post Feb 18 2020, 02:53 PM
Post#8


UtterAccess VIP
Posts: 11,788
Joined: 10-February 04
From: South Charleston, WV


Took a look. Again, my vote is for doing away with the MVF.

--------------------
Robert Crouser
Go to the top of the page
 
access2009eg
post Feb 25 2020, 01:28 PM
Post#9



Posts: 1,172
Joined: 19-February 08



Thanks, friends;

for the advice

sometimes client request a certain feature

thanks.gif
This post has been edited by access2009eg: Feb 25 2020, 01:28 PM

--------------------
I would like to Thank you for your help
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    31st March 2020 - 07:18 AM