åbn formular fra en database i anden database

You will need to open the dB using automation

Dim ObjA As Access.Application


    Set ObjA = CreateObject("Access.application")
   
    With ObjA
        .Visible = True
        .DoCmdOpenForm "FormNameGoesHere"

        'From here you will need to play around a bit, I  havent tried myslef

        .Forms!YourForm.YourField = "Some Shit" '???

end with

Set objA = Nothing

an dyou may need a reference to Access too

I might have screwed up in the storytelling...but the database2 is an already excisting database. Therefor I guess I need to write in the path etc.

Terry dont leave me hanging

sorry, me not thinking, back soon

this works
Function OpenAccess()
Dim ObjA As Access.Application


    Set ObjA = CreateObject("Access.application")
   
    With ObjA
        .Visible = True
        .OpenCurrentDatabase "C:\Openme.mdb"
       
        .DoCmd.OpenForm "form1"

        'From here you will need to play around a bit, I  havent tried myslef

        .Forms!form1.text1 = "Some Shit" '???

End With

Set ObjA = Nothing
End Function

Right, thanks

selv tak og god weekend