Using parameters in Access

P

Phildl

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?
 
S

Steve Schapel

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.
 
Top