Open report VBA script

[benjamintsims]

Hi

Can anyone help me with a problem I am having getting a command button to open a report?

The VBA script generated by the wizard is

Private Sub openreport_Click()
On Error GoTo Err_openreport_Click


stDocName = "Recharge schemes all data"


Exit_openreport_Click:
Exit Sub

Err_openreport_Click:
MsgBox Err.Description
Resume Exit_openreport_Click

End Sub

But this is resulting in nothing happening when I click on the button.
Any ideas?

Thanks
Ben

 

[jkl0]

After:

stDocName = "Recharge schemes all data"

Add:

DoCmd.OpenReport stDocName

 

[benjamintsims]

Unfortunately that causes the report to print!
Any other ideas?

 

[jkl0]

Sorry !

DoCmd.OpenReport stDocName, acViewPreview

 

[benjamintsims]

Thanks, that works!

The next question is can I open the report so as to enable the use of hyperlinks in the report?