If you want to open a new form from another Access file you can use following code:
Public Sub OpenForeignForm()
Dim appAccess As Access.Application
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase "C:\MyPath\DataBaseName2.mdb"
appAccess.DoCmd.OpenForm "FormName"
Set appAccess = Nothing
End Sub
No comments:
Post a Comment