Show report in front of pop-up form

  • Thread starter Thread starter Luke Bellamy
  • Start date Start date
L

Luke Bellamy

Hi - I have a form that is set to pop-up, so it shows on top.
On this pop-up form you can click on a button and show a report
that is not set to pop-up. So the report shows up behind this form.
I have it set this way for a variety of reasons that will take a while
to explain.
But my question is... is there a way I can display a report and then
force it to show on top (at the font) of this pop-up form?

Since it's an mde I don't believe I can set the pop-up property
in design mode and save it based on the form I'm in. Just had trouble
with making design time changes within an mde.

Any suggestions appreciated.

Thankyou,
Luke Bellamy
Newcastle, Australia
 
Luke

One approach might be to "kill" the pop-up (I assume it was opened as
"dialog", with Modal and Pop-up set on) in the Report-Open event. That way,
the Report would show up "on top".

I suppose if you needed the pop-up AFTER the report, you could use the
Report-Close event to re-open it.

Or does your report rely on data collected on the pop-up? If so, consider
changing that from opening as a "dialog" form...
 
Hi - I have a form that is set to pop-up, so it shows on top.
On this pop-up form you can click on a button and show a report
that is not set to pop-up. So the report shows up behind this form.
I have it set this way for a variety of reasons that will take a while
to explain.
But my question is... is there a way I can display a report and then
force it to show on top (at the font) of this pop-up form?

Since it's an mde I don't believe I can set the pop-up property
in design mode and save it based on the form I'm in. Just had trouble
with making design time changes within an mde.

Any suggestions appreciated.

Thankyou,
Luke Bellamy
Newcastle, Australia
Click to expand...


Code the command button on the form
DoCmd.OpenReport "ReportName", acViewPreview
Me.Visible = False

Code the report's Close event:
'either close the form
DoCmd.Close acForm, "FormName"
'or make it visible again
Forms!FormName.Visible = true
 
Back
Top