[AccessD] Re: query criteria

Bob,

When using the grid a "0232" Or "0224" gets turned into ... WHERE 
tblXYZ.[Field] = "0232" Or tblXYZ.[Field] = "0224"

When using a textbox (ie, forms![frmABC].txtValue, you get .... WHERE 
tblXYZ.[Field] = "0232"  Or  "0224"
-- not a valid SQL statement.

- Wayne


----- Original Message ----- 
From: "Bob Heygood" <bheygood at abestsystems.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Tuesday, May 17, 2005 2:31 PM
Subject: query criteria


> 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
>
>
>