Docmd Method With If Loop

[Eranka]

Hi

 IF(DoCmd.OpenReport "User_Details", acViewNormal) Then
MsgBox "Report Printed Successfully"
Else
MsgBox "Report Not Printed"

is this above code correct? if not what changes to be done?

[Minty]

If a report won't print you'll get an error, use this to tell your user there was a problem.
It won't tell you it has printed correctly as far as I'm aware.

There is a discussion here that might help https://access-programmers.co.uk/for...d.php?t=204812

[Eranka]

Hey Minty

Awesome, that worked. Thanks alot mate.