View report in front of form

[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

 

[Allen Browne]

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

 

[Guest]

Allen -

Many thanks! That did it!

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