Results 1 to 5 of 5
  1. #1
    thegrimmerdiscovery is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2017
    Posts
    30

    Transpose Multiple List Box Selections to Table

    Hi



    Is the a suitably easy way for an Access novice to capture the selections from a list box so they are recorded in a table. There wil usually be more than one item selected from the list box. I've looked for help on this but what I've read is way to advanced for me and full of VBA and loops and stuff.

    It seems to me that Multi Value Fields might be an alternative approach, but after reading any number of warnings about these, and in the interest of trying to go about things the correct way, I've swerved them. However, my database is very simple. It's never going to be migrated to a SQL server. I'd appreciate your input.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    don't use multi select lists. They require programming.
    instead, use a single select, then on dbl-click add the item to a tPicked table (via append query)
    this table can be joined to the main data table to act only on those chosen items.
    No programming needed.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    thegrimmerdiscovery is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2017
    Posts
    30
    Thanks for making that clear Ranman - that would explain why I've been unable to get this moving.
    Orange, the values in the listbox are in a juntion table.

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    OK, then please describe the business involved in simple terms -- just as you would describe the "requirement" to someone who doesn't know you, doesn't know database.
    If the data you need is already in a junction table, can you show us a graphic/screenshot of your relationships window?

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

Similar Threads

  1. Replies: 4
    Last Post: 05-30-2019, 02:13 PM
  2. Replies: 1
    Last Post: 03-23-2015, 10:13 AM
  3. Handling Multiple Selections in a List Box
    By Zetony in forum Access
    Replies: 2
    Last Post: 11-02-2011, 02:21 PM
  4. Replies: 2
    Last Post: 05-27-2011, 08:12 AM
  5. Multiple Selections from a List Box
    By oleBucky in forum Forms
    Replies: 4
    Last Post: 05-06-2011, 08:24 AM

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