Hide Report after Opening?

[Heatshiver]

I have a form that opens two reports. I need to hide one of the reports after it opens. I then need to add a button to the 1st report that makes the 2nd report visible again.



I know of Me.Visible = False

This has not worked for me. I placed this in the On Load, On Open, and On Activate events of the 2nd report, but when the reports open from the form, the 2nd is still visible. I am aware that I could close the 2nd report and have the 1st one re-open it, but that would defeat the purpose as I need the values from the form (check background below).

I was thinking of one solution:

1) In VBA have the form make the 2nd report invisible once the code to have it open is run. Then have a button on the 1st form to make it visible again. My issue is that I only know how to use Me.Visible. How do I call a report and make it invisible on a different form/report? (In either case I am curious to know how to refer to a report instead of using "Me")

Any help/insight would be much appreciated. Thank you!

BACKGROUND:
The form has two date fields where the user chooses a start and end date. The 1st report bases it's values solely on the end date, while the 2nd report uses the range of dates from start to end. If I close the 2nd report instead of hiding it, then I have to have the user go to another form and click the button to use the same start and end date.

[pbaldy]

It would be the same as this:

Forms Refer to Form and Subform properties and controls

except you'd use "Reports" instead of "Forms". You can hide it with one of the arguments of OpenReport.

[pbaldy]

By the way, if you just open them both in Preview mode, one will stack on top of the other so the user can review one, and when they close it the other will be sitting there. At least that works for me.

[Heatshiver]

So Reports!ReportName should work instead?

Beyond that, you're a genius! Thank you very much. Didn't even notice that option in the macro.

[pbaldy]

Happy to help. Don't forget to post something wherever you posted this so people don't waste their time.

cross posters