[AccessD] Process multi-select listbox

Ooh. Ooh. I think I know this one.

    For Each varItem In lstOrders.ItemsSelected
        strList = strList & lstOrders.Column(0, varItem) & ";"
    Next varItem

Yes?

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com
Sent: Monday, March 05, 2007 7:01 AM
To: AccessD at databaseadvisors. com
Subject: [AccessD] Process multi-select listbox

I can't remember how to do this. (Been concentrating on SQL for the past
while.) I have a multi-select listbox whose column of interest is a
single-letter such as "A", "B", "C", etc. I want to grab all the selected
items and create a string by concatenating the single letters.

Something about lstMyBox.Selected with a For/Next wrapped around it, but I'm
fuzzy on the details. I've done it in past apps but cannot remember. 

Pushes in the right direction appreciated.
TIA,
 
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.7/710 - Release Date: 3/4/2007
1:58 PM