Open External DB Form

crislbr1

New member
Local time
Today, 00:18
Joined
Nov 18, 2009
Messages
6
What is the simplest way to open a form from an external DB? I know how to link tables, but I was wondering if I click a button, what would be the code needed to open a form from another DB.

Any help is appreciated.

Thanks,
Brendan
 
Something like this might work
Code:
Dim msApp As Access.Application
Set msApp = GetObject("C:\temp\YourDatabase.mdb")
msApp.Visible = True
msApp.DoCmd.OpenForm ("FormName")
Cleanup:
msApp.Quit acQuitSaveAll
Set msApp = Nothing
 
That did it. Thank you.
 

Users who are viewing this thread

Back
Top Bottom