Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Thanked 0 Times in 0 Posts

    LIst Box - Multi-Selection (2002)

    How do you go about setting up a list box so that you can select several choices and save all the choices to a field. I selected simple in the multiselect property of the listbox and I can select several choices in the box but they do not seem to save in the field. Do you have to write some code to do something after you select the choices?



  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: LIst Box - Multi-Selection (2002)

    I wouldn't recommend storing multiple values in a field - it violates relational database design. Instead, create another table linked to the main table, with a separate record for each value.
    And I wouldn't use a multi-select list box for selecting the values, but a main form - subform setup instead. A list box would require quite a bit of code, while Access will do all the work for you if you use a subform linked properly to the main form.

    What then is the use of a multi-select list box, you ask? You can use it to let the user select options, as an alternative to a series of check boxes.

Posting Permissions

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