[b]Print multiple reports using form[/b] 1

[whodeycp]

I have set up this form for previewing reports based on a value that is selected in a combo box. The value is being passed through a paremeter query which will produce the report. I need to be able to produce 4 additional reports based on the number selected. For example, say the user chooses the year 2006, they want the reports for 2006, 2007, 2008, 2009, and 2010 or even 2011 if one of the other years does not have data. They are trying to see what projects there are in the upcoming years. Does anyone have any idea how to do this, I am stumped. So like I said, four years ahead of the what was selected. Thanks.

 

[randy700]

Something like...

Dim x As Integer
For x = 0 To 4
   DoCmd.OpenReport "rptName",,,"fieldname = " cboName + x
Next x

Randy