Results 1 to 5 of 5
  1. #1
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314

    Multivalue Combo-check-box

    I recently converted a couple of Combo-boxes in my database to multi-value/select Combo-check-boxes, because it was convenient to be able to make multiple selections in continuous forms, when needed. This works great.

    However, there is one drawback. When they were single-value/select combo-boxes, I could quickly copy and paste a value from one combo-box into others, when their values should be the same. This avoided the more tedious process of selecting the value/values in each instance, in such cases.



    I now find, that these multi-value/select Combo-check-boxes do not support pasting values into their fields. Anybody know of a workaround to allow pasting into these multi-value Combo-check-boxes.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Multi value boxes take too much VB coding.
    Using single select lists and dbl-clicking it to run append query that adds the item to a 'picked' table needs no programming.
    Just run a query on the dbl-click event.

    then in the query, join the pick list table to the data table to pull the needed data.

  3. #3
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314
    Multi-value combo-boxes have a built in feature to allow selecting multiple values. I didn't need to do VB coding to create multi-value combo-boxes.

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by WCStarks View Post
    I recently converted a couple of Combo-boxes in my database to multi-value/select Combo-check-boxes, because it was convenient to be able to make multiple selections in continuous forms, when needed.
    While you may find it "convenient" to use a MVF, it id difficult to get the data out for reports/forms without code.

    I have heard of very few (if any) experienced Access Developers that use MVFs or Lookup Fields.
    The main problem with MVFs is that Microsoft did not fully implement them. What happens behind the scenes (from what I understand) is Access creates a junction table that is not easily accessible.
    You would create the same table if you created a normalized table structure/relationship, but you would be able to access the data in the junction table.



    Good luck.... I fear you have created future problems for yourself.

  5. #5
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314
    I'll investigate what you have suggested. I should note that I haven't seen a problem yet with MVFs in my reports. The reports were not modified, but they do display the multiple values, just as they did the single values.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Check two combo box if null
    By margzj in forum Access
    Replies: 17
    Last Post: 08-19-2017, 08:10 AM
  2. Invisible Combo box and Check box
    By Amen in forum Access
    Replies: 3
    Last Post: 10-06-2013, 06:54 PM
  3. set value in combo box based off check box
    By scowens36 in forum Forms
    Replies: 2
    Last Post: 09-29-2011, 08:46 AM
  4. Check Box to Combo Box
    By Yakisobi in forum Access
    Replies: 1
    Last Post: 07-21-2011, 06:59 PM
  5. Check for numbers in a combo box
    By slenish in forum Programming
    Replies: 2
    Last Post: 03-17-2010, 07:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums