Using Multiselect list boxes in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Pockmire - 14 Dec 2006 22:56 GMT

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?

Reply to this Message

Douglas J. Steele - 15 Dec 2006 01:38 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> 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?

Reply to this Message

Allen Browne - 15 Dec 2006 01:39 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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?

Reply to this Message