Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Storing multiple values (Access 2000)

    Subject edited by HansV to be slightly more specific than 'Access'

    I am trying to set the value of a combo box to an existing table...that was a piece of cake [img]/forums/images/smilies/wink.gif[/img] Where I'm not having a problem is getting the database to store the data I have selected in my combo box, which allows multi-selection. The purpose of the form is to input inventory that will also have keywords stored about each item to allow for keyword searches. My inventory table has a keyword field in it...my keyword table just has all the fixed keywords that would be assigned to an inventory item...again, will have multiple keywords for one item...am I totally approaching this from the wrong angle? Any help is greatly appreciated!

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

    Re: Storing multiple values (Access 2000)

    Let's get the terminology straight first. Are you sure you mean a combo box? Combo boxes (aka dropdown boxes) don't have a multiselect feature, but list boxes do.

  3. #3
    New Lounger
    Join Date
    Mar 2006
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Storing multiple values (Access 2000)

    Sorry. Slip of the finger...list box...and I want to select multiple values and have those values then populated in my table that is storing each inventory item...

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

    Re: Storing multiple values (Access 2000)

    The "standard" way of doing that is to use a separate table for the keywords, in which each inventory item/keyword combination is a record, and to use a subform for the keywords instead of a multi-select list box.

    Take a look at the very simple demo attached to <post#=364,203>post 364,203</post#>.

Posting Permissions

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