Pop Up reports

  • Thread starter Thread starter James
  • Start date Start date
J

James

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

Many Thanks

James
 
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?
 
So how do I do that then?

Do I just do a docmd.openreport, , acDialog

Or something like that?

Many Thanks

james
 
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
 
Back
Top