I created a report that uses a parameter query to select records from related tables into a report. It works fine to create a single report at a time. The parameter query prompts for a value when I open the report. It creates the report and I print using Access pulldown menu. I close the report and open it again to create the next report...etc.
I would like to have the user enter as many as 10-15 values to select multiple records to create/print seperate reports for each value.
I have 4 related tables with a key value of CYCLE. One table has revision information, another table has cycle description information, and another table contains detail steps for each cycle. Each cycle could have as many as 15 detail steps. There must be only 1 cycle on each report.
I'm not sure where to start.
Thanks in advance for any suggestions.
I would like to have the user enter as many as 10-15 values to select multiple records to create/print seperate reports for each value.
I have 4 related tables with a key value of CYCLE. One table has revision information, another table has cycle description information, and another table contains detail steps for each cycle. Each cycle could have as many as 15 detail steps. There must be only 1 cycle on each report.
I'm not sure where to start.
Thanks in advance for any suggestions.