Values from a text box as query criteria
Posted on 2001-06-18
I have a form. It's a lovely form. On this for I have a text box. I want to use the value in this text box in the criteria section of a query. The value in the box looks something like this:
"OUT_MACHINE = 'Machine1'" Or "OUT_MACHINE = 'Machine2'"
When I paste this explicitly, right into the criteria box, it works just dandy. When I refer to the text box on the form, i.e.:
It goes kaflooie. It seems that when access reads it explicitly, it reads it as "Value 1" or "Value2", but when it reads it from the text box, it reads it all together as a string, like so:
" "OUT_MACHINE = 'Machine1'"Or"OUT_MACHINE = 'Machine2'" "
so the value will never match correctly to this string and the Or clause is not recognized as a clause at all but as part of a sentence for all intents and purposes. How do I get around this? It's driving me buggy!