Opening Crystal Report and Passing Report via Acess VBA

Here it is kids.

I have a button and I can make it launch crystal reports

- c:\crystal reports\cr32.exe

Is there someway to modify the command to open a particular report???

Thanks

are you using VB6?

Looks like your running this from Access VBA module? If so then you can pass the report as a parameter two ways.

VB Code:

Shell "c:\crystal reports\cr32.exe C:\MyReport.rpt"
'Or
ShellExecute Application.hWndAccessApp, "Open", "c:\crystal reports\cr32.exe", "C:\MyReport.rpt", "C:\", SW_SHOWNORMAL