[AccessD] query criteria

Bob Heygood bheygood at abestsystems.com
Tue May 17 16:31:53 CDT 2005


Hello to the list,
Why might I not get any results from a query that uses a text box on a open
form for one of the criteria for one the query's fields?

I can type the same text into the criteria myself and the query returns the
proper set.

BTW, this only goes bad when using more than one value. These are text
types.

Example:
Works in grid:
"0232"
"0232" Or "0224"

Works in Form textbox:
0224

No work in Form textbox:
0224 or 0232
"0224" or "0232"

TIA,

Bob Heygood





More information about the AccessD mailing list