Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi select list box on a form (2003)

    I have been searching for a way to make my list box a "multi selection" (on my form) with a button to save to the database - but all I have found as far as explanations - is VB code.

    I am working on learning VB - but this database has a quick time line and is only temporary until the web app is developed.

    Is there a way to create a multi select list box on a form in Access without using VB or very little VB?

    Thank you,
    Vicky

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

    Re: Multi select list box on a form (2003)

    You don't need code to create a multi-select list box, but you do need code if you want to store the selected values in a table.

    The attached sample database demonstrates how that can be done. The code isn't terribly complicated, but not trivial either.
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Mar 2004
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi select list box on a form (2003)

    Thanks Hans, I learn so much on this site!
    I will look at this and see if it is justifiable for me to create 8 of these - with a database that will only be used for 3 months.
    Vicky

Posting Permissions

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