Results 1 to 3 of 3
  1. #1
    Swin69 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    3

    Problem updating a table from a multi-select list box


    I am trying to make a simple database where the data entered in a form will update to a table. My issue is, one of the fields is manufacturing location where I would like the user to be able to enter multiple locations and then have those locations update the table where the record is stored. I've been able to set up a list box with multi-select but am stuck at getting the table to update with the choices made from the list box selection. Anybody have any ideas?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Did you first set up the field in table to allow multi-values? Must set the Lookup in table then the multi-value property will be available. Listbox is bound to field?

    I have never used multi-value fields and don't want to ever.
    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
    Swin69 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    3
    Thank you that's what i was looking for - i agree with you about the multi-value fields but this was a special circumstance. My problem stemmed from starting off with a database that was created on a 2000 version of access (multi-value fields were not available then) I had to restart the database using the 2010 version and all is well

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

Similar Threads

  1. Several fields vs multi-select list vs other?
    By DarthZ in forum Database Design
    Replies: 1
    Last Post: 02-15-2012, 10:28 AM
  2. Multi select list box and DELETE query
    By thart21 in forum Programming
    Replies: 1
    Last Post: 01-08-2012, 08:47 PM
  3. Multi select list box
    By foxtet in forum Forms
    Replies: 1
    Last Post: 05-30-2011, 02:13 PM
  4. Replies: 1
    Last Post: 10-22-2010, 10:11 AM
  5. Multi-select List Boxes
    By Rawb in forum Programming
    Replies: 6
    Last Post: 09-21-2010, 09:02 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