SUB REPORTS

[Hightower]

I have a report with 6 sub reports that are used to
calculate class information. What is the best way I can
prompt ONCE for a class number and not have to retype the
class number for each of the sub reports? Currently I'm
type in the same information 7 times.

 

[Duane Hookom]

Don't use a parameter query. Set the criteria in your report record sources
to a reference to a control on a form. This might look like:
Forms!frmYourForm!txtYourTextBox

 

[Bob Hightower]

Mr. Hookom, thank you for your help, the process worked
very nicely.
Bob