Using Multiselect list boxes in a query

[Jim Pockmire]

Is it possible to use data in a bound column of a multiselect list box in a
sql select statement - especially linking to another table?

 

[Douglas J. Steele]

Not directly. You have to dynamically generate the SQL, as illustrated in
http://www.mvps.org/access/forms/frm0007.htm at "The Access Web"

 

[Allen Browne]

Not directly, no.

If you are good with VBA code, it's possible to craft a function that
returns True if the field value passed in matches an item in the
ItemsSelected collection of the multi-select listbox. You can probably
search http://groups.google.com/advanced_group_search?hl=en for examples.