opening report from a 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
 
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
Click to expand...
using "DoCmd.OpenReport "rptMeal",
 
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
 
Back
Top