Printing selected records

[bobjackson]

I have two tables. One called Index which contains all the main data. The second called PrintIndex in which the user can select a number of records from the Index to print.
I have now hit a snag. I have printed only one page of a report where the Tag is a specific record, but how do I get it to print only the records that are listed in PrintIndex in a report. Never smile at work, they may think you're enjoying yourself too much and cut your pay.

 

[hymn]

Create a query from Table printIndex Save as (????)
Set the criteria to what is required
On the Record Source of your report set it to the Query name(????)

Hope this helps

 

[bobjackson]

Thanks, I had thought about creating a query, but I already have a query set up and linked to the report. When you are in the form inputing the data on a specific record there is a print button that if you click prints the current record. Hence I need to maintain that query so it can see all the records for that form.
I have twenty different reports for different record types. The only way I could find a way to do it was create a second query and report for each record type but this increases the database size more than I would like. If I could somehow do away with the second query or unless there is a way I can get a report to look at two different queries using some code it looks like my only solution. Never smile at work, they may think you're enjoying yourself too much and cut your pay.