Want to open a form in another db to interact with currentdb

[LikeThisName]

can anyone show me in psuedo code how i would open a form in another db. or suggestions on why not to bother with this approach.

so much to learn, thanks!



LikeThisName <- ? Sorry It's Taken =)

 

[mck144]

Dim db as new access.application

set db = CreateObject("Access.Application")

db.OpenCurrentDatabase pathname

db.DoCmd.OpenForm formname, acNormal, , , acFormEdit, acWindowNormal

db.Visible = True

I know you asked for psuedo code but I happened to have the code right in front of me. Remember to close the database that you connected to when finished with the form. Probably with On_Close event

Hope this helps

-Mike

 

[LikeThisName]

even better, i wrote psuedo code, i meant code snippet

here's a star for being a mind reader =) and thanks for sharing.



LikeThisName <- ? Sorry It's Taken =)

 

[mck144]

Why thank you