Bring Report Window to Front

B

Barry Skidmore

Because of the way in which I am opening a report, it is displayed
behind a form window. Using Visual Basic or a macro, how can I bring
this report window "to the front", based on its name?

Thanks,
Barry
 
A

Allen Browne

You can give focus to a report with:
DoCmd.SelectObject acReport, "Report1"

If your form is a popup, it may still float over the report.

If the form is opened in dialog mode, it will also remain in front of the
report unless you set its Visible property to No, or open the report in
dialog mode also (available in Access 2002 / 2003 only).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top