How refer to Parameter query in row source?

M

mscertified

I have a query I need to run from two different forms, The query needs a
parameter from a control on the form. How do I specify the paramater in the
control's row source?
 
D

Duane Hookom

Text box controls don't have a Row Source. I expect you mean the Control
Source of a control. How are you entering the parameter and how does your
report know the parameter value?
 
L

Larry Koehler

Reference the Form control in the Criteria line of the query with the
following syntax:Forms![Myspecialformisnamedthis]!
[MySpecialFormTextBoxForTheParamaterIsNamedThis]. As long as the form is
open when you go to the run the query, the query will be able to get the
paramater from the named control object on the form.
 
Top