To simplify my reports, I am planning on making three reports that will all differ to print data from the same form. This is due to some reports needing features that others will not. When the user clicks print on the form, I only want one of the reports to print though.
The report would be selected based on the current record set pulled up in the form. I.E. if that record set contains a number 5 then print report 1, a number 7 then print report 2, or a number 9 then print report 3.
I have the form and report printing fine right now when I reference the report directly in the macro and switch it out for each report.
I tried setting up a Macro with Open, Print, Close commands for each report with conditional statements defining which form to select. It seemed it only looks at the first record in the data set it is printing and makes the call then moved to the next command which dosent work.
Any help to make this work would be great, thanks