Results 1 to 2 of 2
2001-08-31, 20:47 #1
- Join Date
- Feb 2003
- Melbourne, Victoria, Australia
- Thanked 0 Times in 0 Posts
Multi select list box (Accesss 2000)
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.
2001-09-01, 00:34 #2philmarcusGuest
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.