Multiselect Listbox

[dt1969]

How do you pass a variable from a multiselect listbox to an param query? I am able to capture the selected items but cannot pass them to the param query. Here is what I have so far:
With Me.listMng
For nCounter = 0 To (.ItemsSelected.Count - 1)
For nColCount = 0 To .ColumnCount

var = var & .Column(nColCount, .ItemsSelected.Item(nCounter)) & ""
Next
var = var & vbCrLf
Next
MsgBox var
End With

what I need to to is for each item selected in Me.listMng to be passed to a param query for export.

this is the last piece of my db and am pulling out my hair, any assistance would be gratefuly recieved.

thanks

 

[Steve101]

Please explain what you are trying to do; what are the parameters of the parameter query; are they the items extracted from the listbox, or something else. Its unclear how you relate whats been selected in the list box to what you would like to export via the query.
More detail required please.
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)