View report in front of form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

This is probably a very easy question to answer, but my VBA skills are rusty
to say the least. I have a report that opens from a command button on a
form. That works fine, except the report always opens behind the form. I
would like it to appear in front of the form on opening. How do I program
this?

Thanks

Tom
 
Tom, open the form in design view, and make sure its Popup and Modal
properties are set to No. The report will then open over the top of the form
(unless the report is already open when you execute your OpenReport.)

It is possible in Access 2002 and 2003 to force a report to open in dialog
mode, but this has other side effects and so is not a good solution. If you
want to try, it's:
DoCmd.OpenReport "Report1", acViewPreview,,,acDialog
 
Allen -

Many thanks! That did it!

Tom

Allen Browne said:
Tom, open the form in design view, and make sure its Popup and Modal
properties are set to No. The report will then open over the top of the form
(unless the report is already open when you execute your OpenReport.)

It is possible in Access 2002 and 2003 to force a report to open in dialog
mode, but this has other side effects and so is not a good solution. If you
want to try, it's:
DoCmd.OpenReport "Report1", acViewPreview,,,acDialog
Click to expand...
 
Back
Top