What are you previewing it with?
Does it not have paging controls?

the code i am using is as follows:

Details

For i = 1 To 12
    
       Me.Calendar = DateSerial(Year(Calendar), i, 1)
       StartDate = Me.Calendar

       While Weekday(StartDate) <> 1
            StartDate = StartDate - 1
       Wend
       MsgBox StartDate
      
       ' DoCmd.OpenReport "MonthlyCalendarR", acViewPreview
       DoCmd.OpenReport "MonthlyCalendarR", acViewNormal
      
       MsgBox (Forms!DatePickerF!Calendar)
   Next i
Copy

In the above loop you can see that i preview, although currently commented out, with acViewPreview
and auto print the report on each loop with acViewNormal

regards

Alfred

I don't know about paging controls, could you point me in the right direction

You could do it by making the monthly report a sub-report. It's a work-around, that it should do it.

Ideally, you would generate a single report that's got all 12 months' worth of data in it, but if you want each month printed out in the monthly format, then that gets tricky.

Thanks Richard,

Yes I want it in monthly format so that i can add an image on each month to create a family Calendar as presents

This would actually make a pretty cool TechHelp video. I don't think I've covered something like this before: how to get specific sub-report items to show. Give me a couple of days, and I'll make a video explaining how this works. In a nutshell, basically, you'll create a master report for the year and then you'll create 12 subreports, one for each month. Linking them is tricky, but I'll show you how to do it in the video.

Many many thanks Richard

Live Long and Prosper………

Richard Hi Richard,
I have recently returned from China and was just wondering if you have created the new video or not - just in case i have missed it.  Apologies for the follow-up.

Regards
Alfred

After looking into this more, I actually do have two videos that kind of show how to do this. They both show how to take multiple subreports, even if they're related or unrelated, and put them together in the same parent report. Check both of these videos out.

Subreports
Combine Reports

What I am going to do, though, and I did put this on my to-do list, is I am going to make an annual calendar sub-report for the new 2.0 version of the calendar template that I'm still working on. But essentially, all you have to do is you've got a monthly report that looks good, right? Just embed that as a sub report and then change the record source so it only displays a single month. And then copy and paste that 11 times and change the month. Watch those two other videos, and if you still can't figure it out, let me know.

Ok, thanks.

Sorry about chasing it up

Best Regards
Alfred

Alfred no worries, it's still on my list for a full video. I've just been busy. I haven't had time recently, but it's still on there. But I figured I'd just give you a rough idea of how to do it.