Results 1 to 6 of 6
  1. #1
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065

    Multi-Select Listbox


    I have a form in Microsoft Access 2010 There are 3 list boxes that contain 14,3 and 7 items. Each of those listboxes are multi select so there can be any combination of items. I've now been told that each of the selected items in each listbox will also need the Assigned Date. Can a list box contain 2 columns with 1 being editable so the date can be entered?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    No.

    The Assigned Date should be in separate field.

    Are these listboxes bound to multi-value field?

    Really need a separate related child table for these multiple values.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065
    No they are not bound to a multi-value field. it is a child table

    Parent table is for the employee
    There are 3 child tables

    1 for the applications assigned to that employee
    1 for the hardware assigned to that employee
    1 for the systems that employee as authorized to enter.

    The structure of each of the child tables is very similar

    employeeid
    childid (AppID for applications, HWID for hardware, and loginid for systems
    Date Assigned


    Primary key is employeeid and childid

    the list boxes are tied to the lookup tables for each of those systems

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    If listbox is not selecting items for a multi-value field, why is it multi-select?

    Each item selected should create separate record. The date value must be entered into another control.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065
    Was trying to avoid using subforms thought a listbox would work. It doesn't thanks. Will use the subform. Thanks

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    A multiselect listbox can work for a normalized child table, but it's a bit of work. I sometimes use one for initial data entry and then use a subform for maintenance. Here's the data entry part:

    http://www.baldyweb.com/MultiselectAppend.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. pbaldy - Multi-Select Listbox
    By jasbrown in forum Forms
    Replies: 9
    Last Post: 01-31-2013, 11:22 AM
  2. Search using a multi select listbox
    By noobaccess in forum Access
    Replies: 13
    Last Post: 12-04-2012, 07:06 AM
  3. multi select listbox
    By crowegreg in forum Forms
    Replies: 3
    Last Post: 07-28-2012, 01:48 PM
  4. Looping through a multi select listbox - how do I do it?
    By shabbaranks in forum Programming
    Replies: 4
    Last Post: 04-02-2012, 11:56 AM
  5. Need Multi-Select listbox code example
    By Buakaw in forum Forms
    Replies: 4
    Last Post: 08-21-2011, 08:37 PM

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