Change from report view to print view in code

[suepowell]

HI,

I have a report which I want to open in report view as a dialog so I can add some buttons to ok some updates.

This works fine.

I then want to print the data on this report, which means I need to change to printpreview.

As the report is in dialog mode I can't do this.

is there a way of changing the current view of the report using VBA, or should I just get the calling form to open the report again immediately the first instance closes.

thanks

Sue