Like Criteria Question using a control from a Form
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
|