Hi there
Can anyone help me out the the code needed for when the user clicks a command button within a form on database1, it opens up a form on database2. Both databases are held within the same path/directory. I have managed to open database2 using:
Dim wsp As Workspace
Dim dbs2 As Database
Set wsp = DBEngine.Workspaces(0)
Call GetDatabasePath
Set dbs2 = wsp.OpenDatabase(strDatabasePath & "databasename.mdb"
but I can't work out how to open a form from dbs2, maybe I am going down the wrong route?
any help would be appreciated.
thanks
Can anyone help me out the the code needed for when the user clicks a command button within a form on database1, it opens up a form on database2. Both databases are held within the same path/directory. I have managed to open database2 using:
Dim wsp As Workspace
Dim dbs2 As Database
Set wsp = DBEngine.Workspaces(0)
Call GetDatabasePath
Set dbs2 = wsp.OpenDatabase(strDatabasePath & "databasename.mdb"
but I can't work out how to open a form from dbs2, maybe I am going down the wrong route?
any help would be appreciated.
thanks