Selecting Value in Subform Text Box in Qry

[Jlacey91]

I'm struggling to set my criteria correctly in my query to look up the value entered in a text box on a subform.

My Main Form is called "NavigationFormMaster", Subform: "DepositCheck1", Text Box: "DriverNo"

My criteria is:



Like "*" & [Forms]![NavigationFormMaster]!DepositCheck1].[DriverNo] & "*"

Where have I gone wrong?

[June7]

What happens - error message, wrong results, nothing?

There is a missing [ in front of DepositCheck1.

Review
https://www.accessforums.net/forms/t...orm-32053.html
https://www.accessforums.net/forms/f...77/index2.html

I don't use dynamic parameterized query. I prefer http://www.allenbrowne.com/ser-62.html

[Jlacey91]

Sorry, the "[" is on the query, miss-typed.

It brings up an "Enter Parameter Value" box that I have to fill in twice to get the result I was looking for.

[June7]

You have two threads running on this same topic. Pick one and stick with it. You are getting basically same information in both. I should either merge them or delete one.