List box Multi-select VBA Code ‘Let me check my list…’
August 19, 2009 | 9:21 amList box magic is found in another classic article by Microsoft Access guru Doug Steele
In this article, Doug Steele looks at various ways of using the List Box control including Multi-Select , moving items between lists, using non table record sources and showing all tables in a database in a list box. Full Article Reprint Here.
List Box object has an ItemsSelected collection which provides a means to access data in the selected rows. The code that Doug shows you will allow you to pull all the items that were selected on the list box.
Enjoy the article!
Bob Heifler
I really enjoyed reading this article. I seldom use list boxes because the size that they require and the complexity of building a custom list box. Doug Steele covered this subject, making building list boxes a lot easier. His articles are always very informative, comprehensive, and practical.
I only wish that we could have downloaded the example file to use as a guide.
-Rick