Use subform in other database

[Gerwin Berentschot]

Hi there,

I have a main db in which I referenced a sub db. From the main db I open a
form in the sub db that has a subform control. In this subform control I want
to show a form that is in the main db. When setting the sourceobject of the
subform control (me!subView.sourceobject="frmTest") I get an error that the
object does not exist.

Any suggestions or workarounds!

 

[George Hepworth]

Import the subform into the mdb where you want to use it.

 

[Gerwin Berentschot]

George,

Of course in many cases that would be a solution, but for a number of
reasons I have to keep the subform in the original db.

Gerwin