Reports and sub reports

[Guest]

I have several sub reports put into one report. They are all based off of the
same select query. The select query requires that I enter the criteria before
it runs. When I run the report it makes me input the same criteria for each
page of each sub report. So I end up entering the same data a bunch of times
to generate each page of the report?

 

[Duane Hookom]

Don't use parameter prompts in your queries. Use references to controls on
forms in the criteria.

 

[Guest]

I appreciate your help but I am not sure I understand it. My data is relative
to football plays and teams, I am trying to pear down the data to display
only one team in the report.

 

[Duane Hookom]

Then create or use and existing form where the user selects a team. Assuming
you have a form named "frmRptSelect" with a combo box to select the team
"cboTeamID". You would set the criteria in the report's record source query
to:

Forms!frmRptSelect!cboTeamID

Parameter prompts are very poor in terms of flexibility, functionality, and
friendly user interface. Don't use them.