Help.Chris
Registered User.
- Local time
- Today, 13:54
- Joined
- Oct 11, 2000
- Messages
- 43
I have a form with a multiselect list box, this is populating a text box with a criteria so search on in a query. The criteria is formated with or's in it,
ie.
selection1 or selection2 or selection 3
When I reference this text box in query is works with only 1 selection, but multiple brings up no results. I thinks Access is enclosing the string in quotes, so one works, but in multiple selection the quotes are going round the whole string. I have tried using " in the string around each selection but this returns no results at all.
Does anybody have any idea what I can do.
Thanks for any help in advance.
Chris
ie.
selection1 or selection2 or selection 3
When I reference this text box in query is works with only 1 selection, but multiple brings up no results. I thinks Access is enclosing the string in quotes, so one works, but in multiple selection the quotes are going round the whole string. I have tried using " in the string around each selection but this returns no results at all.
Does anybody have any idea what I can do.
Thanks for any help in advance.
Chris