Opening Reports in VBA

[rpbenito]

How do I open a report in VBA and have it pop up in the front window on top of all the other forms open?

Thanks


Pat

 

[mp9]

DoCmd.OpenReport "YourReportNameHere"

http://www22.brinkster.com/accessory/

 

[rpbenito]

Thanks, but that code only prints the report...the code I'm using is

DoCmd.OpenReport "contact_general_info", acViewPreview

it opens the report up to view, but behind the current form. I need it to open up in front of the current form...thanks in adcvance...

Pat

 

[dysphoric]

After the command to open the report, insert:

DoCmd.SelectObject acReport, "contact_general_info", False

This selects the report as the active object.

 

[rpbenito]

Thanks for the help, but after inserting the line of code nothing changed. Any other suggestions?

 

[dysphoric]

Check the properties for the forms and make sure that none of them are set to "popup".

Popup forms will still show on top of active objects.