L
LarryP
I sometimes need to pass the results from a multi-select list box to a query,
e.g., "Apple" or "Orange" or "Grape" etc. I've done this before by writing a
bunch of code to build a concatenated string from an array of selected
values, but it gets kind of tedious. Anybody know of a slick way to tell a
query "use all the values in this array as criteria, and accept anything that
matches"? Or better yet, "Use everything that has been selected in control
x", skipping over the whole array part? I could probably write a function to
do that, but I'm hoping some whiz out there has already done so and I can
shamelessly plagiarize. It would be really nifty to just put
=StuffInControlX() as a query criterion!
e.g., "Apple" or "Orange" or "Grape" etc. I've done this before by writing a
bunch of code to build a concatenated string from an array of selected
values, but it gets kind of tedious. Anybody know of a slick way to tell a
query "use all the values in this array as criteria, and accept anything that
matches"? Or better yet, "Use everything that has been selected in control
x", skipping over the whole array part? I could probably write a function to
do that, but I'm hoping some whiz out there has already done so and I can
shamelessly plagiarize. It would be really nifty to just put
=StuffInControlX() as a query criterion!