Like Criteria Question using a control from a Form

  • Follow


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
0
Reply Utf 6/7/2010 8:46:03 PM

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
0
Reply Utf 6/7/2010 9:29:14 PM


1 Replies
773 Views

(page loaded in 0.061 seconds)

Similiar Articles:
















7/18/2012 10:50:02 AM


Reply: