Report with Subreport Shuts Down Access on Close

[randommetalguy]

I have two reports MainReport and SubReport.

Sometimes I want to display the subreport and sometimes I don't. This is controlled by a VBA variable.

Either way, whether the subreport is visible or not when I close the main report is makes entire Access shut down.

I can go from ReportView to DesignView without any problems, but If i do a print preview, try to go to another form, or close the report Access just hangs and eventually shuts down.

Am I missing something here? Do I need to close the subreport first then close the main report? Ideas?

 

[marianne]

there is no wrong if you close the mainform. your problem is shutting down.

1. maybe you have create code docmd.quit instead of docmd.close
2. if number one doesnt solve your problem maybe you have to uninstall and reinstall your access again.