Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

ACCESS reports appear behind form

new preview report appears behind the form
how can i have the preview of the report appear in front of the form
0
wildm4n
Asked:
wildm4n
2 Solutions
 
Dale FyeCommented:
You should be able to do this by changing the windowmode (second to last last argument in the OpenReport method)

docmd.OpenReport "rptname", acViewPreview,,, acDialog

You might also be able to accomplish it by changing the Popup property of the report (on the Other tab of the properties dialog) to Yes.
0
 
Helen FeddemaCommented:
Or hide the form when the report is previewed.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Also, make sure the "Form" is not opened in Dialog or pop-up mode...
As this will prevent other windows (ie, ...your report) from opening up on top.

All in all, if the form is opened normally, ... and the report is opened from a button on the form, ...the report should be on top.
This is the standard behavior.
.
0
 
wildm4nAuthor Commented:
both worked

the second solution was the best for my situation
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now