Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Multivalue Combo Box
Elena Chiozza 
    
3 years ago
I was wondering if it was possible to build a multi-value combo box with a many-to-many relationship junction table so without the lookup wizard, I am at Expert Level 8, should I wait until I get to grips with some advanced VBA?
Thank you for reading:)
Scott Axton  @Reply  
        
3 years ago
See the Multivalued video.  It explains why they are not recommended how to get rid of them, and alternatives to use.
Elena Chiozza OP  @Reply  
    
3 years ago
Thank you very much Scott, I thought that it was possible to build an actual combo box as opposed to a list box, is there such a thing or is it a big no no? I can't seem to find the answer, I appreciate your time so if you can't answer I'll understand. Thank you again:)
Scott Axton  @Reply  
        
3 years ago
Maybe terminology is the issue here.  Are you just wanting to choose an item from a list?
That would be a Relational Combo.

If you need multiple choices to be true then take a look at the Multiple YN
That shows how to be able to choose multiple items in the correct way.

If I'm not understanding correctly, maybe you can give us an example of what you are trying to accomplish so that we can help you better.
Kevin Yip  @Reply  
     
3 years ago
As Scott said, multivalue fields are difficult to work with, in queries and in VBA.  Use MVF only if you need a multiple-choice type of combo box with checkboxes (see picture below).  But I would rather find other more manageable ways to do the same thing than using MVF to do it.
Kevin Yip  @Reply  
     
3 years ago

Elena Chiozza OP  @Reply  
    
3 years ago
Hi Kevin, Hi Scott,
That's exactly what I meant, the MVF. That's because the subform with checkboxes, although a viable option, it is not so good to look at and to work with in the long run, but certainly something it can get you by if you don't know VBA well yet. So I guess the answer is that I will have to wait until I get to use VBA properly to open a dropdown menu with checkboxes? OR does the option not exist at all, better to have multiple distinct fields, that is, different relational combo boxes to select from?
Thank you both for your input!
Kevin Yip  @Reply  
     
3 years ago
Hi Elena, Richard has a video on using "fake combo boxes" that offer you more options on their looks and functionalities:

     https://youtu.be/FET8JG8w4Xg

Basically, you use subforms for that.  You turn off their borders, record selectors, etc. to make them look "plain," and make them invisible or visible when necessary.

To add checkboxes to a combo box without using multivalue fields, i the combo box's rowsource needs to have a built-in Yes/No field.  You may need to create a temporary table for that.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 12:54:21 PM. PLT: 0s