List box Multi-select VBA Code ‘Let me check my list…’August 19, 2009 | 9:21 am
List 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!