Pop Up reports

[James]

Is there any way to get a report to pop up when its called
from a button on a form?

Many Thanks

James

 

[Wayne Morgan]

It appears that the acDialog WindowMode argument applies to the DoCmd.OpenReport call,
just as it does the OpenForm call. Is this what you are asking?

 

[James]

So how do I do that then?

Do I just do a docmd.openreport, , acDialog

Or something like that?

Many Thanks

james

 

[Fredg]

James,
If you want the report to be on top of everything else, and for all further
processing to halt until you close the report, then:
DoCmd.OpenReport "ReportName", acViewPreview, , , acDialog

Watch the commas!!!!!

Otherwise

DoCmd.OpenReport "ReportName", acViewPreview
Me.Visible = False ' Optional, if you also wish to hide the form