Report not opening on top

  • Thread starter Thread starter Eric C
  • Start date Start date
E

Eric C

Hello,

When I open a certain report I created, it opens behind
the current form. I need this report to be on top, until
it is closed by the user. How do I go about doing this.
My code is:
DoCmd.OpenReport "schTEACHERLISTACTIVEBYSCHOOL",
acViewPreview, , , acWindowNormal

Thanks,

Eric
 
Eric said:
Hello,

When I open a certain report I created, it opens behind
the current form. I need this report to be on top, until
it is closed by the user. How do I go about doing this.
My code is:
DoCmd.OpenReport "schTEACHERLISTACTIVEBYSCHOOL",
acViewPreview, , , acWindowNormal

Thanks,

Eric
Click to expand...
Eric,
Just make the form not visible.
DoCmd.OpenReport "schTEACHERLISTACTIVEBYSCHOOL", acViewPreview
Me.Visible = False

You can then either close the form

DoCmd.Close acForm, "FormName"

or make it visible again

forms!FormName.Visible = True

from the report's Close event.
 
Try ending with acViewPreview - this will use the default
settings:
DoCmd.OpenReport "schTEACHERLISTACTIVEBYSCHOOL",
 
Back
Top