Make my report visible 1

[AlanBornat]

When I preview a report using 'DoCmd.OpenReport "DiarySummary", acViewPreview', the report hides behind another form that I have open. How can I bring it to the front?

 

[RoyVidar]

I'm guessing the form is opened in dialoge mode. One approach, would be to not do so. Another could by to try hiding the form while the report is open (me.visible = false), then unhide it again, in the reporst on close event (forms("frmFormName").visible = true), for the latter, you'll probably want to examine the isloaded property of the allforms collection too (or the isloaded function in the Northwind sample database).

Roy-Vidar

 

[AlanBornat]

Thanks Roy - the form that opens the report was in dialogue mode, but I immediately closed that form and the report was still hidden behind another form that wasn't in dialogue mode. Even so, your first tip worked!