Parameter Report/Subreport question

[Guest]

I have an activity report which displays all of the information for a vendor,
based on a name parameter supplied by the user. The report contains a
subreport which displays some additional comments, based on the same name
parameter.

The problem is, when I try to run the report, it prompts me three times for
the vendor name. The report is fine once it displays, but I wanted to find
out how I can make it so that it only prompts once for the vendor name.

The report and subreport are each based on a query which contains a [Enter
Name:] criteria.

Thanks!

 

[Duane Hookom]

Abandon all parameter prompts in favor of using controls on forms to provide
filtering of your queries/reports/forms.

 

[Guest]

I'm relatively new to access. Can you give me a little guidance on how to do
that?

Thanks!

Abandon all parameter prompts in favor of using controls on forms to provide
filtering of your queries/reports/forms.


--
Duane Hookom
MS Access MVP

I have an activity report which displays all of the information for a
vendor,
based on a name parameter supplied by the user. The report contains a
subreport which displays some additional comments, based on the same name
parameter.

The problem is, when I try to run the report, it prompts me three times
for
the vendor name. The report is fine once it displays, but I wanted to find
out how I can make it so that it only prompts once for the vendor name.

The report and subreport are each based on a query which contains a [Enter
Name:] criteria.

Thanks!

 

[Duane Hookom]

Create a form with controls to enter criteria. The controls could be text
boxes, combo boxes, check boxes,... Name your form and controls so they make
sense like
frmReportCriteria
and
txtStartDate
txtEndDate
cboCategory

Then replace your parameter prompts with something like:
Between Forms!frmReportCriteria!txtStartDate and
Forms!frmReportCriteria!txtEndDate

Open your form and enter criteria values. Then open the report.
--
Duane Hookom
MS Access MVP

I'm relatively new to access. Can you give me a little guidance on how to
do
that?

Thanks!

Abandon all parameter prompts in favor of using controls on forms to
provide
filtering of your queries/reports/forms.


--
Duane Hookom
MS Access MVP

message

I have an activity report which displays all of the information for a
vendor,
based on a name parameter supplied by the user. The report contains a
subreport which displays some additional comments, based on the same
name
parameter.

The problem is, when I try to run the report, it prompts me three times
for
the vendor name. The report is fine once it displays, but I wanted to
find
out how I can make it so that it only prompts once for the vendor name.

The report and subreport are each based on a query which contains a
[Enter
Name:] criteria.

Thanks!