Open Crystal Report through an Access Report Connected to SQL

[Lynn_AccessUser]

Not sure about posting this here, but thought I would give it a try. I have a crystal report written from a stored procedure in SQL. However, the frontend is Access. I need to open the report via an access form. When the report was reading from access tables I used the following code to open the report:

If Reports = "Report Name" Then
CrystalReport.Connect = "DSQ=\\path to dsn file"
CrystalReport.ReportFileName = "\\path to the actual report"
CrystalReport.Action = 0
End If

Where CrystalReport was the name of the ActiveX component.

Thanks