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.