Thanks to
@isladogs for making modifications in my app. He not only solved the issue of hiding app window but also optimized my app in lot other ways too which help me make it better as I develop it.
I applied the settings one by one from modified app (RMS_v2_CR) which is provided in post #15 into the original app to figure out what actually solved the issue so that if anyone is having the same issue, this post can help him. Following steps solved the issue:
1. Change report to pop up.
2. Use following code in the command_click event to open the report
DoCmd.OpenReport "Report Name", acViewReport
3. Add
DoCmd.Restore
in report_open event
I hope this helps.