Printing Reports Casewise

B

BTings

Hello,

I do psychological research and I use Access 2003 reports to automatically
fill in fields for each person participating (ie I print out questionnaires
as reports with the person's name, ID#, and other person-specific fields
filled in).

I know that I can print out a report for some specific cases (ie a report
"x" for cases "1-9"). Is there a way that I can print out all the reports for
a single case (ie reports "x,y, and z" for case "1")?

Thanks for your help
 
L

Larry Linson

It is the RecordSource of the Report that determines the specific records.
You can alter that to match the information that a user has entered on a
Form, with VBA code in the Report's Open event; alternatively, you can add a
WhereCondition argument to the DoCmd.OpenReport statement that is generated
by the Control Wizard when you create a Command Button to open the Report.

You'll need minimal VBA skills. If you don't have that, it is possible that
you can post enough details here that someone can help you with the code.

Larry Linson
Microsoft Access MVP
 
Top