Closing a form and report
Posted on 2012-08-20
I have a Main Form from where I can click on a button which takes me to another form, i.e. Report Menu.
In this Report Menu I can enter a date range i.e. a Start date and and an End Date and preview a Report based on that criteria.
To preview the report I run a macro which opens the Report and then Hides the Report Menu and then maximizes the report.
The reason I do this is because I want the Report Menu Form to continue running in hidden mode so that the report can continue running based on the date criteria entered in the Report Menu form.
My problem now is closing the Report and Report Menu form in such a way so that when I Close the report the underlying form i.e. the Report Menu will also close so that when I re-enter the Report Menu via the Main Menu the Report Menu date range does not retain the date range that I entered previously.
Any Ideas welcomed..