Preview a report from the Access form with acDialog type

[chuongcom]

I develope one Access 2000 application. When active one form with acDialog type, click Preview command on this form to preview a report, I can't see this report, because above form is activing.

Can you help me ?
Thank you very much

 

[Guest_imported]

Hi,
Try this:
Add a command button called Preview to the active form. In the Click event of this button, put in the following line of code.

Private Sub Preview_Click()
DoCmd.OpenReport "yourReportName",acViewPreview
End Sub

This will display the report in the preview mode.