Report Question...

[merciless32]

I have 3 different reports that contain information on vacation travelers. One has their personal data (Personal), one has their financial info (Financial), and the last has their travel data (Travel). All three reports have corresponding tables and a common field in each called Record#.

How do I create a process that will print the reports in order for each user record. In other words I want to print a packet for each user like this:

Record 1 - Personal report, Financial Report, Travel Report
Record 2 - Personal report, Financial Report, Travel Report
Record 3 - ....

Thanks in advance.

 

[AncientOne]

to print individual reports, you create a form with a combo box containing information about your customers.

When a customer is selected from the combo box the appropriate reports are printed by activating macros or a code module.

The report names are listed in sequence and the customer information from the combo is passed to each report in turn.

Look up DoCmd.OpenReport for how this is achieved.

If you want to print out all the reports in one batch, you would have to create a code module to step through the records sequentially. Or base your report on a query that takes in all three tables and create the appropriate fields on separate pages of the report.

 

[merciless32]

Thanks

I out together a few macros based on queries that run the reports in sequence. I used the Where Condition field in the macros to set the criteria for each report. I appreciate the help!