Hi chongo 2002,

I have this in my code to show my Crystal Reports.

Private Sub mnuReportsfrmPreviewShift_Click()
With CrystalReport9
.Destination = crptToWindow
.DataFiles(0) = "H:\Software Development Projects\Maintenance database\Maintenance Data.mdb"
.ReportFileName = "H:\Software Development Projects\Maintenance database\Summary By Shift.rpt"
.Action = 1
End With
End Sub

I also put the crystal report control on the main form, so that it would not trouble with showing the report. You can get that control from Project, Components, then select the crystal report control and apply.

Good luck!

jeffro