Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Baton Rouge, LA
    Posts
    26

    Red face Unanswered: Multi Select List Box

    Hey guys n' gals...

    I am new at this, and usually just fool around in access to learn about it.

    I have created a table 'tbllog' and have a form bound to it. On the form, I want to have a list box with a few items in it available for multi select use:

    NB
    SB
    WB
    EB

    When I choose one or more of these items, I want them to populate a field 'direction' in tbllog. Easy enough if it is single select listbox. Selecting 'NB' will populate the field direction. But I want it to be multi select, so that if I choose 'NB' and 'SB', then I want 'direction' to be populated with 'NB;SB' or something to that effect.

    Any ideas?
    Beau B. "desigBEAU"

  2. #2
    Join Date
    Jan 2004
    Location
    Baton Rouge, LA
    Posts
    26
    If I'm not making any sense, please, let me know.
    Beau B. "desigBEAU"

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Try looking at the ItemSelected property of the listbox. I also believe that this question has been answered numerous times in the past ... I posted some code showing how to retreive the items selected and from there it is an easy thing to slap those in a textbox.

  4. #4
    Join Date
    Jan 2004
    Location
    Baton Rouge, LA
    Posts
    26
    Originally posted by M Owen
    Try looking at the ItemSelected property of the listbox.
    I've seen ItemSelected refered to in previous posts, but have never seen it in the properties window for the listbox. I am using Access 2002. Clue?
    Beau B. "desigBEAU"

Posting Permissions

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