Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Posts
    32

    Unanswered: Multiselect Listbox

    I want the user to be able to select more than one option from a listbox. How do I do it?

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    There should be a property on the Listbox called Multi Select, change it to Simple or Extended (see help file for the difference if you are unsure).
    Me.Geek = True

  3. #3
    Join Date
    May 2003
    Posts
    32
    I have selected the multiselect option. It allows me to pick more than one selection but it does't save it to the table. If I only choose one option, it saves it to the field. How do I save multiple options to the table?

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    That depends on your save method. More information needed!
    George
    Home | Blog

  5. #5
    Join Date
    May 2003
    Posts
    32
    I want to be able to save the multiple options to one field. I make the selections and then close the form with an autosave option on close. I then check the table and the "Content" field is empty. If I only choose one option from the list box, it is saved in the "Content" field.

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Ah, multiple options to one field, eh? Well, if you posted your code, I imagine we could see that you are only passing one value to your update/insert procedure.
    Create a new button and run this code:
    Code:
    MsgBox Me.MyListBoxName.Value
    Select one item and click the button, then try it with a multiselect. Tell us what you find.
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •