parameter question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

report after parameter form 3
Parameter Query In Report Title 3
How to enter a Wildcard or Is Null into a query paramater ? 7
how to pass a parameter to a query base of a query that is the base of a report 0
Query Parameter using multiple options 0
Repeat titles in multiple columns report 1
Parameter Value error in a Subform 0
Report Query Parameters 2

Back
Top