Report previews behind form

[Guest]

I have a button on a form that opens another form that contains a list of
reports that can be printed. If I select a report and pick PREVIEW, the
report appears but it appears behind the original form. I want the report to
appear in front of the original form and not at full size. I do not want the
original form closed though. After I preview the report and close it, I want
the original form to still be there.
How do I accomplish this?

Thanks
Stonewall

 

[Allen Browne]

The report will appear on top of the form unless:
a) the report is already open, or
b) the form's Popup property is Yes, or it was opened in Dialog mode.

To solve (a), close the report and open it again, or SetFocus to it.

To solve (b), change the properties/mode of the form.

In Access 2002 and later, it is possible to open a report in dialog mode to
force it to take focus, if you have a special reason for making it modal
like that.