reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have six subreports in my report, all linked to a separate query. When
run, each query asks for a student ID #. When I run the report it asks for
the student ID # about 50 times before running the report, and then again for
each subsequent page of the report. Is there a better way?
 
Vanessa said:
I have six subreports in my report, all linked to a separate query. When
run, each query asks for a student ID #. When I run the report it asks for
the student ID # about 50 times before running the report, and then again for
each subsequent page of the report. Is there a better way?
Click to expand...


Time to scrap those clumsy Prompt parameters and start using
a form for users to enter the criteria value.

If you don't already have a form with a button to run the
report, create one.

Add a text box named txtStudentNum to the form. Then change
all the queries to use criteria like:
Forms!nameofform.txtStudentNum
instead of the [Enter Student ID #] that you are currently
using.
 
Don't use parameter prompts in your queries. Replace them with references to
controls on forms. Your criteria would then be something like:

Forms!frmStudSelect!cboStudentID
 
Back
Top