Saving selections from listbox

D

Damon Heron

First of all, I have an option frame that filters the listbox based on which
option is selected. That works fine. Then I click on the selections in the
listbox and put them in a second list, with a cmd button, and using this
code snippet (this is not all of the code, but it should be familiar to most
of you)-

For intCurrentRow = 0 To ctlSource.ListCount - 1
If ctlSource.Selected(intCurrentRow) Then
AWGs = AWGs + CSng(ctlSource.Column(2, intCurrentRow))
WGs = WGs + CSng(ctlSource.Column(5, intCurrentRow))
strItems = strItems & ctlSource.Column(0, intCurrentRow) & ";" &
ctlSource.Column(1, intCurrentRow) & ";" & ctlSource.Column(2,
intCurrentRow) & ";" & ctlSource.Column(3, intCurrentRow) & ";" &
ctlSource.Column(4, intCurrentRow) & ";" & ctlSource.Column(5,
intCurrentRow) & ";"
ct = ct + 1
End If
Next intCurrentRow

This also works fine.

What I want to do, though, is to move from option to option and "remember"
the selections from each, so the user would be left with, as an example,
one from option A, two from option B, one from Option C. My question is,
how? or is it possible? There is also the problem of the user de-selecting
items at any point in the process. I would like the user to see a final
list in the second listbox that he would then save. I have no idea where to
start......
Many thanks to any suggestions.
--Damon Heron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top