open access app from within another access app

[erodjob]

Using access 97 and windows xp. I have a command button that on double click, I want it to open another database. However, I get error message
" Microsoft Access can't invoke the application using RunnApp action."

This is the code I'm using"

Private Sub CorpInvestment_DblClick(Cancel As Integer)

Dim stAppname As String

stAppname = "MSACCESS.EXE \\pershing.com\root\shared\NJ\BONDS\Contacts\Corp-Investment.mdb"

Call Shell(stAppname, 1)

End Sub


any suggestion

 

[Norie]

In form design just go to Insert>Hyperlink.

Or on certain controls there is a property Hyperlink Address, or something like that.

Using first method will give you a lable hyperlink.

The second method could be used on a command button.

 

[erodjob]

Thanks, it worked.

I will use this option for now.