cant use report because form

[adaniele]

hi guys,
i have a form with a button. when i press the button it opens a report :

DoCmd.OpenReport "popreview", acViewPreview, acWindowNormal

the problem is that the report is in the backround and i cant use it until i close the form.

the form is setup as a popup.

is there any way to use the report and have the form opened at the same time?

thx, max.

 

[ansentry]

is there any way to use the report and have the form opened at the same time?

I will stand corrected, but I say NO if you have the form set to pop up. This is what Access help says;

The form opens as a pop-up window. It remains on top of all other Microsoft Access windows

 

[Oldsoftboss]

In A2002, the reports have a popup property also

Dave

 

[JoeCruse]

I had a similar situation. I got around it by putting code in the Open Report button to hide the pop-up form when the report opens. Then, when I close the report, the On Close code of the report checks to see if the form Is Loaded, and unhides it if it is. Works great.

Is Loaded is not a "formal" function, but you can copy it out of the Northwind example database that comes with Access.

 

[KeithG]

Why can't you close the form when the report opens? You could write code to reopen the form when you close the report. You could also change the popup property of the form to false when the report opens. You will also need to change the modal property to false if it is set to true.

 

[adaniele]

guys, thx for your advise and suggestion.
i had forgotten to set the popup property to yes in the report. So, now the report is on the top. However, i try to chg the popup value via vb code and it fails. here is my code:

forms!formname.popup=false

thx, max.