List Boxes with Alternate States

[#1]

I have two list boxes.  Each List box is in its own state.  If I select 5 "vendors" in one of the list boxes, how do I use Select in Field (in a button) to also chose those "vendors" in the second list box.  I have been using the expression below to make the selections in the Select in Field search string but it will only work for one "vendor" at a time.  I need to select all vendors at once.  Does anyone understand what I am doing wrong?

=Concat(DISTINCT {[Category Analysis]} Vendor, '|')

[swuehl]

Have you tried like this:

='(' & Concat(DISTINCT {[Category Analysis]} Vendor, '|') & ')'

[#3]

This is partially working but it is only selecting names with no spaces. Is there is a space in the name it does not work. Any idea on how to work around this?

JEREMY TERLESCKI

SOURCING OPERATIONS ASSOCIATE

T: 484.690.5418

E: jterlescki@procurian.com<mailto:jterlescki@procurian.com> | W: procurian.com<http://www.procurian.com>

CONNECT WITH PROCURIAN ON:

<http://www.linkedin.com/company/procurian?trk=hb_tab_compy_id_164269> <https://www.facebook.com/Procurian> <https://twitter.com/Procurian> <http://www.youtube.com/user/Procurian>

[swuehl]

I believe values with spaces need to be surrounded by double quotes, so try this:

='("' & Concat(DISTINCT {[Category Analysis]} Vendor, '"|"') & '")'