Kevin Elliott
New member
- Local time
- Today, 20:32
- Joined
- Mar 6, 2013
- Messages
- 3
Hello everyone,
I have a list box which allows return of multiple values. I have some VBA which builds a string of all the values returned, and has put a comma between each value selected.
The values at the moment are just numbers, so the string looks like
307, 328, 400, 420, 502
I have a query with an IN statement in the criteria field. If I hard code these values (with parentheses) it works fine, but if I try to pass in the value of a text box which contains the string of values, it doesn't return any data at all if I have two or more numbers in the string. One number on its own is fine.
Any help would be very much welcomed! :banghead:
Cheers,
Kevin.
I have a list box which allows return of multiple values. I have some VBA which builds a string of all the values returned, and has put a comma between each value selected.
The values at the moment are just numbers, so the string looks like
307, 328, 400, 420, 502
I have a query with an IN statement in the criteria field. If I hard code these values (with parentheses) it works fine, but if I try to pass in the value of a text box which contains the string of values, it doesn't return any data at all if I have two or more numbers in the string. One number on its own is fine.
Any help would be very much welcomed! :banghead:
Cheers,
Kevin.