Report with window mode acDialog

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

I have created one form frmParam for users to enter parameter for one of my
report, In click event of OK button I have included following code"
....
'evaluate arguments here and stores into cArgu variable.
....
Me.Visible = False
DoCmd.OpenReport "MyReport", View:=acViewPreview, _
WindowMode:=acDialog, OpenArgs:=cArgu
Me.Visible = True

It displays the report and waits till I hit ESC. But the problem with report
view window is, I can not print the report means I can not click on print
button and and view window is small window and I can not resize window.

It works fine if I use normal window mode but then it doesnt wait for users
to view and comes back to param form.

Can anyone suggest me the solution ?

Thanks
 
Surely -- Change your logic so the parameter form doesn't have code waiting
to execute when you return from viewing the report.

Larry Linson
Microsoft Access MVP
 
Is there any way I can print report if I have opend the report from form in
acDialog mode?
 
Back
Top