Formulation of a criteria for a query (1 Viewer)

Hi guys,

Creating a query in design view, I want to use the value of a particular text box in an open form.

So, I write something like this in the 'Criteria' row of the query design view:
So be it. It works.

Is there any possibility to tell the query to pick up the criteria from the currently open form instead of having to designate it by name?

My point is to be able to use the same query from two different forms, using of course values from text boxes which have the same name.

I hope I explain myself clearly enough...

Short version is no. One option is to take criteria out of the query and use this for forms/reports:

http://www.baldyweb.com/wherecondition.htm

another is to have a hidden form (or hidden textbox(es) on a form that stays open all the time). Your query gets the criteria from there, your 2 forms copy the value there before running the query.

No. My advice is to create a report, base it on the query you are using without any criteria or parameters, then when the user clicks a button on the form to open the report it uses DoCmd.OpenReport (https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openreport) to open the report while passing a filter string to the report to show just the records you want.

you might want to use Tempvars as criteria to your Query, eg:

but, you need to add code to each Form's Current Event: