Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    May 2003
    Location
    Pennsylvania, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple selections in combo box (Access 2000)

    On the Web, you frequently see dropdown boxes (i.e. combo boxes) with the instruction "CTRL-Click for multiple items". Can I do the equivalent in Access using a combo box? If so, How?

    I'm designing a form to collect data about a group of people, and one of the things I need to know is what language(s) they speak. I set up a subform in datasheet view to allow them to input more than 1 language, but this looks ugly and may be confusing to the users. I'd really like to use a combo box if possible.

    Thanks.

    Don.

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Multiple selections in combo box (Access 2000)

    You can't select multiple items using a combobox in Access however, that option would be great. However, you can select multiple items using Control-Click using a multi-select list box.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple selections in combo box (Access 2000)

    Use a multiselect list box instead of a combobox. Comboboxes return to their default height of one row when the focus moves away from them, so a multiselect combobox would not display all the choices made. Access listboxes and comboboxes are two different controls, unlike VB where the properties of the control determine whether it has a dropdown, and there is no multiselect combobox in Access. If you are set on this, you might be able to find a 3rd party control, but that would require both special programming and installation on all the affected machines.
    Charlotte

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple selections in combo box (Access 2000)

    Hi Don

    Take a look at this. Got it off Woodys last June

    HTH

    John
    Attached Files Attached Files

  5. #5
    Star Lounger
    Join Date
    May 2003
    Location
    Pennsylvania, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple selections in combo box (Access 2000)

    I was able to create a list box and set the multi-select property to Extended. But nothing showed up in the underlying data table. The table is called Languages, and it is bound to the main person's table by ID. The Languages table is also linked to the LanguageList table which supplies the data for the list box. What I want to happen is to have Languages end up with data that looks like:

    ID Language
    1 English
    1 French
    1 Italian
    2 Sanskrit
    2 Greek

    etc.

    What am I doing wrong?

    Thanks.

    Don.

  6. #6
    Star Lounger
    Join Date
    May 2003
    Location
    Pennsylvania, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple selections in combo box (Access 2000)

    John:

    This looks neat: How does it work--I wasn't able to figure it out.

    Don.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple selections in combo box (Access 2000)

    Binding a multi-select list box to a field won't work. You will have to handle it in code - populate it in the On Current event of the form, update the table in the After Update event of the list box. If you do a search for multiselect list box, you should find some examples. Frankly, I think that a continuous subform is easier.

Posting Permissions

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