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
Who is Participating?
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.
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.
Helen FeddemaCommented:
Or hide the form when the report is previewed.
wildm4nAuthor Commented:
both worked

the second solution was the best for my situation
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.

All Courses

From novice to tech pro — start learning today.