Prev: Using a combo box to determine which field to search.
Next: Function of colon between table names when query in design vie
From: DawnP277 on 7 Jun 2010 16:46
I am trying to do a like criteria with 2 wildcards using a text box as the
parameter.
The original data comes from our ERP system that I ODBC to.

Everything I read tells me I am writing the criteria correctly but it will
not pull any data or I get an ODBC fail message. But if I take out the Form
control as the parameter and just type the parameter it works.

Here is my criteria

Like"*" & [Forms]![NewBlockForm]![Text0] & "*"

Does anyone have any suggestions as why this is not working.

I am trying to filter down the results that the production people need to
view to decide what is the best part number.

Thanks for any help you can provide.

Dawn
From: KARL DEWEY on 7 Jun 2010 17:29
Try this --
Like "%" & [Forms]![NewBlockForm]![Text0] & "%"

--
Build a little, test a little.


"DawnP277" wrote:

> I am trying to do a like criteria with 2 wildcards using a text box as the
> parameter.
> The original data comes from our ERP system that I ODBC to.
>
> Everything I read tells me I am writing the criteria correctly but it will
> not pull any data or I get an ODBC fail message. But if I take out the Form
> control as the parameter and just type the parameter it works.
>
> Here is my criteria
>
> Like"*" & [Forms]![NewBlockForm]![Text0] & "*"
>
> Does anyone have any suggestions as why this is not working.
>
> I am trying to filter down the results that the production people need to
> view to decide what is the best part number.
>
> Thanks for any help you can provide.
>
> Dawn
 | 
Pages: 1
Prev: Using a combo box to determine which field to search.
Next: Function of colon between table names when query in design vie