John Ruff
papparuff at attbi.com
Wed Apr 16 10:47:00 CDT 2003
Using Multiselect listboxes are not as difficult as you are making them out to be. Here's some simple code: dim varItm as string dim strBrand as string strBrand = "" ' Get the value of the first column of all items ' selected in a list box For Each varItm In lstBrand.ItemsSelected strBrand = strBrand & lstBrand.Column(0, varItm) & ", " Next varItm John V. Ruff - The Eternal Optimist :-) Always Looking For Contract Opportunities "Commit to the Lord whatever you do, and your plans will succeed." Proverbs 16:3 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark Sent: Wednesday, April 16, 2003 6:50 AM To: accessd at databaseadvisors.com Subject: [AccessD] Multiselect List box I am working on a program in A2K, and I may have a need to use a multiselect list box. Actually, I think it would be best, because the choice have the potential to be altered in the future. However, I have never used multiselects before, and I am wondering how much trouble I'm getting into. I am all for diving in and learning something new, but I am really pressed for time here...this program must be put into operation by May 1st, and I am also playing a major part of moving an office of 200+ people to a new building, which starts on the 24th...I have to move and setup their server and all routers. Should I just make the check boxes for now? Or are the multiselects easier than I am making them out to be? I don't think I'd have a problem with their actual setup, but taking the selections and putting them into the table is where I am a little confused. Thanks! John W Clark _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com