Multiselect listbox on form

[damo317]

I am using a listbox with extended multiselect listbox (values coming from a seperate 1 field table).

I have read through the forums and worked out how to save the multiple values to my table, and that is working fine. My problem is that i now want to have those values selected on the listbox when i am viewing the form.

I am using ; as the field seperator when I am storing the values to the table.

How can I then view the stored values on the form, as I don't want to use a seperate textbox on the form, I want to view it on the original listbox.

From what I can see Access's string parsing functions are pretty poor, is there anyway I can do what I'm trying to do?

 

[damo317]

I found it.

I didn't know about the function 'InStr'.

I just looped through all possible values, checking if each value was InStr of the entire selected set/row/string, and set selected to true if it was.

Thanks nobody!