convert report view to print preview

[DarrenUD]

Hi All,

I just got in to a another problem with my report and I hope one of you kind people can help me to solve this problem. I have created a access report for a invoice and I have placed few command buttons on the report header like Print to PDF , Print to Invoice and Print Preview. Well, first two buttons working fine and I am stuck with the third button. I want to convert the already open report (in Report view) to print preview. how can I achieve this using VBA. Please Help

[burrina]

Of course, if the report is already open, it will have to close and be re-opened! DoCmd.Close acReport, Me.Name

Dim stDocName As String

stDocName = "YourReportName"

DoCmd.OpenReport stDocName, acPreview

[DarrenUD]

Hi Burrina, it worked like a charm. I don't know what went wrong last time, because I have used a similar code and that didn't work. Anyhow thanks again..

[burrina]

Your Welcome. Glad it worked for you.