opening report from a 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

 

[alan fisher]

Your form probably has the modal or pop up property set to
yes. Try setting the forms property to invisible when you
open the report and then make it visible with on close
property of the report.

-----Original Message-----
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",

 

[Peter]

Ya, you're right. I did set the pop-up property to "yes".

But how do I set the forms property to invisible when I open the report and
then make it visible when closing the report?

Thanks.

Peter