Originally Posted by arnelgp
that is small issue.
before making the report visible, requery it:
Reports("rptQCWeeklyReport").Visible = True
Although the Requery worked, if I close the report and then tried to open it again I got an error becuase the code was looking for a hidden report and couldn't find it. I could have change the close button to hide it again, but I was thinking that if I had multiple reports then would I need to have them all opened and hidden to overcome this problem.
I did come up with a solution myself, simply;
DoCmd.OpenReport "rptQCWeeklyReport", acViewPreview, , , acWindowNormal
DoCmd.OpenReport "rptQCWeeklyReport", acViewReport, , , acWindowNormal
However, I still view this as a work-around rather than getting to the root of the problem.
If anyone has any further suggestions as to the problem then please feel free to let me know.
Thanks to all those who have helped