How can I handle the multi selection values of a list box in a query? :?:
How can I handle the multi selection values of a list box in a query? :?:
One way to do this is create a temporary table that will have the key value of the selected field with a "Select" field (Yes/No).
After some action (say a button click) write some code that will update the Select field with all the choices from the list box. Then in your query, join the field to the temp table and have a condition of "True" for the Select field.
Note: If its a multi user database, the temp table should reside on each user's hard drive rather than on a network drive, to avoid selection conflicts.