Adding "ALL" in Combo Box (1 Viewer)

wraperera

New member
Local time
Today, 06:59
Joined
May 2, 2021
Messages
1
Good-day all,

I am new to Access DB and trying to figure out how to add a "All" button into a combo box where when it clicks it selects all the colors and when its "All" isn't selected it will let me select other options. The issue is when I try to insert "All" in combo box it doesn't actually select all the color, instead it checks the all button but nothing more than that.


Any help is much much appreciated.

COLOR TABLE.JPG


color drop.png

Color Code.jpg
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 10:59
Joined
Jul 9, 2003
Messages
16,244
Have a look at my blog here:-

https://www.niftyaccess.com/combo-filter-all-or-some/

The download is available for free, just use the Discount/Coupon code:- plqovts

If you like the free product, I would be very grateful if you would sign up to my YouTube channel here:-

• Get the Latest MS Access YouTube's HERE:-

 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:59
Joined
Oct 29, 2018
Messages
21,357
Hi. Welcome to AWF!

Since you are using a multi value field (MVF), you will need some code to get what you want.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 10:59
Joined
Jul 9, 2003
Messages
16,244
Regarding multivalue fields. There is an excellent video by:- Takeshi K here:-

Access2010 MultiValued ComboBox​


Not sure it covers what you want, but it is pretty comprehensive I recall.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 10:59
Joined
Jul 9, 2003
Messages
16,244
There's some excellent links about multi value Fields on my website here:-


One of the links points to a previous post where I note that MapJ posted some code examples (which I haven't looked at myself) but may well be worth investigating.

See this thread here:-
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 10:59
Joined
Jul 9, 2003
Messages
16,244
By the way, one of the links for multivalue Fields is to one of our members, Colin (Isladog) excellent blog on why you should not use Multi value Fields! See here for more details:-

 

Users who are viewing this thread

Top Bottom