Opening a maximised report from a PopUp Modal form

[Jim Franklin]

Hi,

I have a dialog box style form, which has Popup and modal properties set to
Yes. I want to be able to open a report from this form and for the report to
be maximised, on top of the form. The report references control values on
the form, so the form must be open when the report opens.

So far the only way I have been able to do this is to open the report, close
the form and then select the report object. But this means when the user
closes the report, the original form is no longer open.

I am sure there is a simple solution to this! Can anyone help me? I am using
Access 2003

Many thanks,
Jim

 

[Arvin Meyer]

As long as you have the modal and popup properties enabled, the form will be on top. The solution is to hide the form, when the report open event is fired. In the report's close event, close the form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley

Hi,

I have a dialog box style form, which has Popup and modal properties set to
Yes. I want to be able to open a report from this form and for the report to
be maximised, on top of the form. The report references control values on
the form, so the form must be open when the report opens.

So far the only way I have been able to do this is to open the report, close
the form and then select the report object. But this means when the user
closes the report, the original form is no longer open.

I am sure there is a simple solution to this! Can anyone help me? I am using
Access 2003

Many thanks,
Jim

 

[Jim Franklin]

Thanks Arvin. Got it to work now, I knew it would be something simple!

Jim
As long as you have the modal and popup properties enabled, the form will be on top. The solution is to hide the form, when the report open event is fired. In the report's close event, close the form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley

Hi,

I have a dialog box style form, which has Popup and modal properties set to
Yes. I want to be able to open a report from this form and for the report to
be maximised, on top of the form. The report references control values on
the form, so the form must be open when the report opens.

So far the only way I have been able to do this is to open the report, close
the form and then select the report object. But this means when the user
closes the report, the original form is no longer open.

I am sure there is a simple solution to this! Can anyone help me? I am using
Access 2003

Many thanks,
Jim