Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2005
    Posts
    220

    Unanswered: Multiselect listbox

    Here's what I am trying to do. I need to allow the user to select 1 or more locations from a multiselect listbox. Once they have selected the locations, I need to insert the values into a table (ie. if they select 5 locations, I want to insert 5 rows into this table for each of the location values).

    How would I do this?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Have you searched? I did and found threads with code. Here's one:

    http://www.dbforums.com/showthread.php?t=983175
    Paul

  3. #3
    Join Date
    Sep 2005
    Posts
    220
    I must have missed that one. That's exactly what I need. I am very new to all of this, so how do I attach this code to the actual listbox?

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Being a multiselect listbox, you probably don't want to do it with any event associated with the listbox. Typically this would be behind a button that the user clicked when they were done making selections.
    Paul

  5. #5
    Join Date
    Sep 2005
    Posts
    220
    Sorry to keep bugging you, but I've not dealt a lot with VB so, how do I take the script you pointed me to and connect that with the click event?

  6. #6
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

Posting Permissions

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