Passing Form Parameter to Query

[jbtman]

I have used some info found here to create a query that pulls its criteria from a form. In the query I specify [Forms]![FormName]!Control and the control is a textbox. But even though there is a value in the textbox it still prompts me for the value to use.

What is the correct syntax for this?

Thank!!

 

[Remou]

Is the form open when you run the query? Have you tried building the criteria by using the Expression Builder?

 

[jbtman]

Yes, the form is open when I run the query but I have not tried the expression builder. I will give it a shot!

 

[Crowley16]

the correct syntax is:
... where forms!formName!controlName = someValue

check that you've spelt everything correctly and maybe post the sql for your query.

--------------------
Procrastinate Now!

 

[jbtman]

What I am trying to do is

Where TableFieldName = Forms!FormName!Control.Value

 

[Remou]

There is nothing wrong with

[Forms]![FormName]!Control

As long as FormName and Control are the right names from the form and as long as the form is open. The Expression Builder should ensure that you are using the right names.

 

[PHV]

Just a note:
FormName must be an open mainform.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886