Using parameters in Access

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

Guest

I have two seperate unrelated queries with the same parameter. I created a
report with one of the queries and ran it and it asked for the parameters
which I was expecting. I then created a sub-report using the other query.
When I now run the report I am asked for the parameter about 8 times and then
again when I go to print the report.

I am obviously doing something wrong. Anyone out there got any ideas?
 
Phildl,

Put an unbound textbox on a form, where you can enter the value
required. In your queries, in the place of the Parameter prompt, refer
to this textbox using syntax such as [Forms]![NameOfForm]![NameOfTextbox]
Of course, the form needs to be open at the time that you print the report.
 
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

Query Parameter using multiple options 0
Using a Parameter Query in a Report? 2
Using Parameters in Graph 7
report after parameter form 3
Enter Parameter Box pops up even though its not in query 7
Report requesting parameter values for removed fields 7
Modify Parameter Query 1
Parameter Value error in a Subform 0

Back
Top