opening a report by pressin button on form

[Peter]

Hi,

I have created a form in MS Access 2000 and it has a button to open a
report.

Button opens up report by using "DoCmd.OpenReport "rptMeal",
View:=acPreview"

But for some strange reason the report opens up below the form. However, I
want it to open up above the form. Is this possible?

Thanks.

Peter

 

[RobFMS]

Is your form opening as a dialog form?

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Luiz Cláudio]

Is it a popup form?

If it is, you can set it's Visible property to false when opening the
report, and then set it back to True when closing the report.

[]
Luiz Cláudio C. V. Rocha
São Paulo - Brazil
MVP Office

 

[Peter]

Oh, ya!.

It is a pop up form.
But how can I set the Visible Property to false when only opening the form?
And then set it to true when closing the form?


Thanks.

Is it a popup form?

If it is, you can set it's Visible property to false when opening the
report, and then set it back to True when closing the report.

[]
Luiz Cláudio C. V. Rocha
São Paulo - Brazil
MVP Office

Hi,

I have created a form in MS Access 2000 and it has a button to open a
report.

Button opens up report by using "DoCmd.OpenReport "rptMeal",
View:=acPreview"

But for some strange reason the report opens up below the form.

However,

I
want it to open up above the form. Is this possible?

Thanks.

Peter

 

[Van T. Dinh]

In the OpenForm Method, you can specify the value acHidden for the
WindowMode argument to open the Form invisibly.

You can use the Report_Close Event to make the Form visible.