If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|