Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi select list box (Accesss 2000)

    Hi,
    It's been a while since I've been here.
    I am creating an app for a local butcher to track his X-mas orders.
    He wants to be able to select from categories of meat (ie. Turkey, Pork, Beef) and from within that category select multiple choices applicable to that category (ie. smoked, baked, large smoked, small baked etc.).
    My approach is to create a form which has all of the categories of meat (six) shown on the form.
    When a particular category is selected, to display a list box only showing those products which are from that category.
    How do I allow the user to select multiple products from the list box and mark/tag those so that I can write them as individual line items to the orders table?
    Thanks in advance.
    Michael

  2. #2
    philmarcus
    Guest

    Re: Multi select list box (Accesss 2000)

    Set the listbox property called MultiSelect to Simple or Extended (the latter is more what a Windows user expects of muli-slection behavior). To read the selections, you must (in VBA) read the contents of the collection listbox.ItemsSelected, each of which is a variant type.
    See Access help on ItemsSelected for more info and an example.

Posting Permissions

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