opening a report by pressin button on form

  • Thread starter Thread starter Peter
  • Start date Start date
P

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
 
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
 
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.


Luiz Cláudio said:
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 said:
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.
Click to expand...
However,
I
want it to open up above the form. Is this possible?

Thanks.

Peter
Click to expand...
Click to expand...
 
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.
 
Back
Top