Open a report from VB6 code ?

[shachar]

i need to open a report that i created in access 97 from a VB6 program and i need help,i need the code that will open a specific report in an mdb file .
10x

[Bigley]

Private Sub Command1_Click()
Dim a As Access.Application

Set a = CreateObject("Access.Application")
a.OpenCurrentDatabase App.Path & "\NWind.mdb"
a.Visible = True
a.DoCmd.OpenReport "Catalog", acViewPreview
a.DoCmd.Maximize

End Sub

That should do it for ya