Open Forms in different databases with same form

[grgimpy]

I recently split my database into three separate databases for various reasons. I'm trying to create one "Control Panel" form with command buttons that open each form from the different databases. I know about the DoCmd.OpenForm coding but from what I've read it only opens forms in the current database. What can I do to accomplish this?

Any help with this would be greatly appreciated.

 

[PWise]

Dim AppAccess1 As Access.Application
Set AppAccess1 = CreateObject("Access.Application")
AppAccess1.OpenAccessProject ("\\XXX\xxx\xXXX\XXXX\XXXX.ade")
Dim AppAccess2 As Access.Application
Set AppAccess2 = CreateObject("Access.Application")
AppAccess2.OpenAccessProject ("\\XXX\xxx\xXXX\XXXX\XXXX.ade")
AppAccessx.docmd.openform "formname"

not tested