Open Another DB to a Particular Form

Novice1

Registered User.
Local time
Today, 04:37
Joined
Mar 9, 2004
Messages
385
I working in a database. I want to open another database and go directly to a specific form (not the default form). How do I make this happen? Below is what I have so far.

Dim accapp As Access.Application
Dim appname As String
Set accapp = New Access.Application
appname = "M:\MPF\MPF_Mgmt_Info_System\SGLIPrepTool\SGLIPrepTool.accdb"
accapp.OpenCurrentDatabase (appname)
accapp.Visible = True
 
Thank you very much ... quick and easy
 

Users who are viewing this thread

Back
Top Bottom