Opening Crystal Report and Passing Report via Acess VBA

[Kid_Coke]

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

[Br1an_g]

are you using VB6?

[RobDog888]

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

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