multiselect example required

[newby2VBA]

I have a form where the user may pick more than one city for the same record using a multi select list box, I want to store the selected choices in a seperate table to keep it normalized. However I want to see the choices in a field on the form separated by ; or | Does anyone have a similar example of this problem or a better solution to handling this. I thought about adding subform on the main form but the selected cities on the list would be spread across 1000+ records and you would have to scroll and remember all the selections.

 

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/MultiselectAppend.htm

 

[newby2VBA]

This is really helpful.I want to show the selection on the main form so I was wondering if you know how I can retrieve from the tblOtherTable the selections made and show it back on the main form in one field, unbound obviously. Or if there is a better way I'm open to suggestions.Thanks for the sample db

 

[pbaldy]

Well, the subform is the typical way. You could get them all into one field with a function along these lines:

http://www.mvps.org/access/modules/mdl0004.htm

 

[newby2VBA]

You are amazing thanks