Results 1 to 2 of 2
  1. #1
    Sarah Lister is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2011
    Posts
    1

    Multiselect List Box does not show selected info in table


    Please can anyone help? I'm a novice when it comes to VBA - I have created a form in Access 2007 for data entry (Vessel Analysis Data Sheet)of boat information. In this form, the 'Foundations' control is a List Box (originates from a table) where users can select more than one item (Multiselect property is set to Simple). I want this information (i.e. their selections) to be sent to the table 'Vessel Analysis Table' in the Foundations field but nothing is showing. I have searched everywhere and can't find the appropriate code - I wouldn't even know where to put the code - can anyone help please?

    Thanks to anyone who can help!

    Sarah

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I think this includes cautions against saving multiple values in one field:

    Bound Multi-Selection List Box Always Returns Null

    Here's a way to populate multiple records:

    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. Replies: 4
    Last Post: 06-16-2011, 09:30 PM
  2. List in Report Won't Show a Column in the Source Table
    By italianfinancier in forum Access
    Replies: 1
    Last Post: 05-28-2011, 02:23 AM
  3. Replies: 3
    Last Post: 01-31-2011, 11:47 AM
  4. HELP! using list boxes with multiselect
    By tarhim47 in forum Forms
    Replies: 21
    Last Post: 11-08-2010, 02:51 PM
  5. Forms + Multiselect list boxes
    By tarhim47 in forum Forms
    Replies: 0
    Last Post: 11-08-2010, 10:50 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