Display reports in front of forms (1 Viewer)

[srideout2525]

First off I'll express my frustration, because dispite the many times I asked this question and been told it couldnt work, I had it working on three of the office computers. That is, when i click a button on a form, I got a preview of a report to display in front of the form, then I could print it.

Yesterday...I added some additional features to MS Office..and guess what, when i click the button the form DOESN'T pop up in front of the form anymore.

So I ask again, how can I make this work. Or what is a way around it.? I don;t want the report to print before I view it, and I dont want to minimize forms to see the report.

please help. if you have any suggestions I'll take them.

(ps..i did try to uninstall and reinstall the basic features..and no luck)

but surely there has to be away to peview reports easily before printing.

thanks

 

[Dugantrain]

In the Report's Properties, set both Pop-Up and Modal to True. This will have the report display in front of other database objects as well as have it keep the focus until you close it.

 

[srideout2525]

I cannot find the Report Properties POP UP or Modal?

Where are they??

 

[Rich]

Either set the forms popup properties to no or toggle their visible property

 

[rat_b76]

Reports in Front of Forms Solution

Hi,

To achieve what you are after, unless your using Office 2003 and higher which has the ability to set report properties to "Dialog" within VBA, the best way to do it is to;
1. On opening the report preview, within VBA set the form properties to hidden
2. On closing the report preview, within VBA set the form properties to visible.

like the following;

OpenReport_Click()
forms!frmYourFormName.visible=false

Private Sub Report_Close()
forms!frmYourFormName.visible=true

This is a quick fire way to get around the problem.