Push information from one DB to another

[Cheshire101]

I want to push the information contained in two fields on my form into specific fields on another form in another database when the form is opened using a command button from the original form.

BTW- I already have the database opening and the correct form open, I just need to figure out how to fill in the information.

Can this be done?

Something like....
Databases![DatabaseName]!Forms![FormName]![FieldName] = Me.Field1

[Cheshire101]

I figured it out:

    Dim objAcc As Access.Application
    
    Set objAcc = New Access.Application
        objAcc.UserControl = True
        objAcc.OpenCurrentDatabase ("DatabaseName.mdb")
    
    objAcc.Forms![FormName]![FieldName] = Me.Field1

Posting the solution in case someone else needs something similar