Like Criteria Question using a control from a Form

D

DawnP277

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a variable in a ShapeRange.Increment 0
Office JS api to handle redo/undo , delete event for content control class 0
Creating a Search using a combo box and then creating a report. 4
Split form 0
Dynamic Naming of Form Button 3
Using "like" from an external link 1
Date and Parameter question. 4
Creating Network Diagram using a Chart SW integration 0

Top