Report preview behind form

[Steve S]

I have a regular with a button to preview a report. The report always opens
behind the form. The form is set up as pop-up and modal so the user can't
see any toolbars or menus. How can I force the report preview to appear in
front of the form? Thanks in advance.

 

[Steve S]

--
Steve S
Let's try this again...
I have a regular form with a button to preview a report. The report always
opens

 

[fredg]

On Fri, 17 Aug 2007 19:18:06 -0700, Steve S wrote:

The usual method is to make the pop-up form Not Visible,
Me.Visible = False
then either close it or make it Visible again in the Report's Close
event.

Either:
DoCmd.Close acForm, "FormName"
or
Forms!FormName.Visible = True

 

[Bob Howard]

I do the same.

I define the report as popup, but not modal, with a control box and close
button,and "both enabled" for min/max. Then in the form, I simply execute a
docmd.maximize after the openreport. I don't mess with visible or anything
like that.

I have lots more to really make this work for me --- write offline and I'll
give you some additional stuff... Basically, I've put a modal popup form in
between my "real" form and the report ... I open it as a dialog ... it opens
the report. I do this so that the user cannot minimize the preview window
and gain access to the form that started it all (because the form is locked
up --- since it has a modal popup dialog on the screen).

bob