Check if list item should be selected

[svjensen]

I have a variable (string) in which I store the users selection from a listbox on a form. The user is allowed to make multiple selections, so the content of the variable could look like '1' (only one selection) or '1,3' (more selections.

On an other form I which to have a listbox with the same values, and as a default the same items should be selected as was the case on the other form.
My idea is to loop through the items in the list (see below) and chech if they are part of the variable. But the last bit is causing me some trouble.

For i = 0 to Me.lstStatus.ListCount - 1
    'If list item is part of variable
        Me.lstStatus.Selected(i)
    End if
Next i

How could/should my if sentence look? Do I need to split the variable and loop through those values as well?

 

[pbaldy]

I would disagree with storing data that way, but here's a set of functions (as well as a caution not to store data that way):

http://support.microsoft.com/default.aspx?scid=kb;en-us;210203

 

[svjensen]

I think you misunderstood me.
I am not storing multiple data in a single field, but I use a variable to pass data from one form to another. The variable contains the ids of the selected items in a listbox and is used to define WHERE clauses.

Anyways, your link helped me to find a solution, so thanks

/Soren

 

[pbaldy]

Glad it helped you.