How to populate a list box with another list box using extended multiselect

[oatsybob]

Hello! As the title indicates, I need to figure out how to populate a list box using another list box on the same form. I have this working completely fine if the the source list box has the multi select property configured to be off, however I need it to be set to extended multi select. Does anyone have any experience with this?

Thanks in advance!!

[Rod]

Rather than going into a long explanation right here, try lookin up ItemsSelected in the Access on-line help. Note that the collection holds not the values themselves but indices that point to the selected values. (Be careful when using indices with listboxes with heading rows!) You then need to build a ';' delimited string and poke this into the RowSource of the second listbox.

For a write-up of multi-select behaviour, select the Multi Select property under the Other tab in the Property Sheet and press F1