Keep on getting a Mismatch

[atrium]

strNewRecord = "SELECT * FROM OrdersOnlyQry WHERE Customer Like " * " & [Forms]![OrdersFrm]![SearchSubform].[Form]![SearchCustomerNameFld] & " * ";"

When I execute the above line I keep getting the mismatch error
The field custome on the Qry is string. In the immediate window I can ?[Forms]![OrdersFrm]![SearchSubform].[Form]![SearchCustomerNameFld] and it returns BLINCO exactly as I want

What should I look at the find the problem

 

[arnelgp]

strNewRecord = "SELECT * FROM OrdersOnlyQry WHERE Customer Like '*" & [Forms]![OrdersFrm]![SearchSubform].[Form]![SearchCustomerNameFld] & "*';"

 

[atrium]

Thank you arnelgp worked wonderfully

Thanks again

 

[arnelgp]

you're welcome.