Parameters in subreports

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

I have a report with 3 subreports. Each subreport uses
the same parameter. How can I pass the input parameter
from one subreport to the next, so the user will not have
to input the parameter 3 times?

Thanks.
 
Simplest solution is to get the queries to read the value from a form.

Create a form with a text box, where the user can enter the value. In the
Criteria row of each query under the appropriate field, enter:
[Forms]![MyForm]![MyTextBox]

It is a good idea to declare these parameters in the query, so it
understands the data type. For example, if this is a date, in query design
view choose Parameters on the Query menu, and enter:
[Forms]![MyForm]![MyTextBox] Date/Time
It also helps to set the Format property of the text box to Short Date (or
General Number or whatever).
 
Thanks, Allen. I'm trying to do that but running into
problems. I will keep trying, following your suggestions
and the Help page "Use a form to enter report criteria".

Does it matter that my main report is unbound?

And will this input date persevere until the entire report
(and subreports) is completed?

-----Original Message-----
Simplest solution is to get the queries to read the value from a form.

Create a form with a text box, where the user can enter the value. In the
Criteria row of each query under the appropriate field, enter:
[Forms]![MyForm]![MyTextBox]

It is a good idea to declare these parameters in the query, so it
understands the data type. For example, if this is a date, in query design
view choose Parameters on the Query menu, and enter:
[Forms]![MyForm]![MyTextBox] Date/Time
It also helps to set the Format property of the text box to Short Date (or
General Number or whatever).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a report with 3 subreports. Each subreport uses
the same parameter. How can I pass the input parameter
from one subreport to the next, so the user will not have
to input the parameter 3 times?

Thanks.
Click to expand...


.
Click to expand...
 
Thanks again! It is now working, and I can proceed with
the project.
-----Original Message-----
Simplest solution is to get the queries to read the value from a form.

Create a form with a text box, where the user can enter the value. In the
Criteria row of each query under the appropriate field, enter:
[Forms]![MyForm]![MyTextBox]

It is a good idea to declare these parameters in the query, so it
understands the data type. For example, if this is a date, in query design
view choose Parameters on the Query menu, and enter:
[Forms]![MyForm]![MyTextBox] Date/Time
It also helps to set the Format property of the text box to Short Date (or
General Number or whatever).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a report with 3 subreports. Each subreport uses
the same parameter. How can I pass the input parameter
from one subreport to the next, so the user will not have
to input the parameter 3 times?

Thanks.
Click to expand...


.
Click to expand...
 
Yes, but what happens when the same report can be opened from two different
forms ?
 
You open the form invisible and place values into the controls that are
required.
 
Back
Top