Popup a form in database A from database B

[Sheryl]

I want to popup a form in database A.mdb from database B.mdb, and use it to
execute further operations in A.mdb. I've already successfully run macros
and queries in A from B by creating an application object 'app', opening
database B, and executing commands like 'app.doCmd.RunSQL myQuery'. But when
I try 'app.doCmd.OpenForm myForm', nothing happens (perhaps it pops up and
down too fast to see).

 

[Andi Mayer]

I want to popup a form in database A.mdb from database B.mdb, and use it to
execute further operations in A.mdb. I've already successfully run macros
and queries in A from B by creating an application object 'app', opening
database B, and executing commands like 'app.doCmd.RunSQL myQuery'. But when
I try 'app.doCmd.OpenForm myForm', nothing happens (perhaps it pops up and
down too fast to see).

You can't use it direct.
put this Sub into a module in A

Public Sub openAForm (FormName as string)
doCmd.OpenForm FormName
end Sub


If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW