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
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