reports

V

Vanessa McD

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?
 
M

Marshall Barton

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.
 
D

Duane Hookom

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
 
Top