Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple items in a list or combo box (2003)

    Is it possible to create a list or combo box (I don't really care which) for a table in Access that lets you select multiple values? I currently have a field that has around 30 possible values, but I would like to be able to select more than one value for some records.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Multiple items in a list or combo box (2003)

    I you have a field a table that can contain more than 1 value at a time, then that field should not be in that table. Instead, it should be in a new table that is on the "many" side of a one-to-many relationship with the master table. During data entry, your form for that main table would have a subform in which you can enter all the values for the field in question.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Multiple items in a list or combo box (2003)

    In addition to Mark's reply (which I agree with), see <post#=364,203>post 364,203</post#> for a sample database showing how to implement a many-to-many relationship.

  4. #4
    Star Lounger
    Join Date
    Nov 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple items in a list or combo box (2003)

    Thanks for the suggestions guys. I've been at a conference for a few days, and have just now gotten the table to (at least for now) work the way I want it. My main goal was to avoid using a form, which I can do because in my primary table I can expand the little plus sign to enter the multiple values. Thankfully, this should be a fairly static table, so I will only have to enter the data once.

Posting Permissions

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