M
M. Nguyen
I tried to create a query with a criteria based on the multiselect string
listbox on the form. I created a function in VBA to get selected values in
the listbox, and concatenated those values into one string separated by
quotes and commas as needed. Then, I put the function name in the query
criteria using the IN(functionname()) criteria expression. However, it
looked like Access only recognized the whole string as one value. How can I
make Access recognize multiple values in one string?
listbox on the form. I created a function in VBA to get selected values in
the listbox, and concatenated those values into one string separated by
quotes and commas as needed. Then, I put the function name in the query
criteria using the IN(functionname()) criteria expression. However, it
looked like Access only recognized the whole string as one value. How can I
make Access recognize multiple values in one string?