parameter question

T

tjtjjtjt

Is it possible to make a query parameter's input appear in a report's header.
I have a report based on a query with a parameter for City. I would like the
City chosen to appear in the header of the report. Is this possible? If so,
how? Any help would be greatly appreciated.
 
R

Rick B

Yes, just include the prompt exactly as you entered it in the query in an
unbound text box on your report....

=[City]

or

= "City: " & [City]
 
L

Larry Daugherty

The easiest way to deal with that is to enter the parameter in a
textbox on the calling form. Both in your Header and in the criteria
line for City put

forms!MyCallingForm!MyTxtControl

Notice that you can refuse to call the form if the control is empty.

HTH
 
Top