open form in another DB (1 Viewer)

[24sharon]

how can I open form that in another file.

I have 2 access files (*.mdb) opened, I want when I click on one I open form in the secend file.

how can I do it?

thanks!

 

[24sharon]

I found this code,

but this code open the database, I want to open form in an opened database, what need I change?

Dim appAccess As Access.Application

   
    Set appAccess = CreateObject("Access.Application")
    appAccess.visible = true
    appAccess.OpenCurrentDatabase "C:\Michal\xx.mdb"
    appAccess.docmd.openform "formFame"
   
    Set appAccess = Nothing

thanks!