Criteria with Form Value

[jtm013]

Hello,



I am sure this is going to end up being a simple solution, but I am just not seeing it.

I have a query which searches records based on the value a user puts in a form field.
The field in question is call TorqueID, and it is a text field.
I use the good ole method [Forms]![frmTquSearch]![torqueID] placed in the criteria location, to search the records.

The problem I am running into is that say I have a TorqueID of "Value" but there is another couple of TorqueIDs "Value Type A", "Value Type B", etc.
If the user inputs "Value" into the field on the form then the query only displays the record with the TorqueID of "Value" and not the type A or type B.

I know if I were to put- Like "*Value*" into the criteria field it would display them all, but how can I do that same effect whilst using a user supplied value from a form field?

Thanks for any and all assistance!
Merry Christmas!

[June7]

LIKE "*" & [Forms]![frmTquSearch]![torqueID] & "*"

Users should not interact directly with tables and queries. I never use dynamic parameters in queries. I use VBA to build filter string and apply to form or report.

[jtm013]

I use VBA to build filter string and apply to form or report.

Don't suppose you could point me in the right direction on that then? I am still very new to VBA.
Thanks for the assist with the syntax on the criteria!

[June7]

Review http://www.allenbrowne.com/ser-62code.html

DoCmd.OpenReport "report name", , , strWHERE

[jtm013]

Thanks for the assist.
Marking as solved.