can I access a form in an mdb from another mdb

[Roger]

I have 2 mdbs (one is a menu system - system.mdb, the second is an
inventory subsystem - inventory.mdb) and there will be more subsystems

the system.mdb knows what forms / reports / submenus / etc to display
and it displays its own objects

now I want to open and use forms in inventory.mdb without using
createObject(access.application..) which opens a separate copy of
inventory.mdb

so in system.mdb, I 'referenced' inventory.mdb and
in inventory.mdb, I created an openForm function that does
docmd.openform....

this works ok for simple forms like 'unit of measure' that have an id
& description

but if the form uses DLookup(), I get an error saying that the table
cannot be found... note... system.mdb does NOT have links to
inventory.mdb tables (and I don't really want to set them up, but...)

does anyone have any ideas on how else to do this ?

[Tom van Stiphout]

On 5 Jan 2004 18:05:50 -0800, le*********@natpro.com (Roger) wrote:

If you don't like CreateObject, use GetObject. Then if GetObject
fails, you can fall back on CreateObject.

The accounting software UA is set up the way you are describing.

-Tom.

I have 2 mdbs (one is a menu system - system.mdb, the second is an
inventory subsystem - inventory.mdb) and there will be more subsystems

the system.mdb knows what forms / reports / submenus / etc to display
and it displays its own objects

now I want to open and use forms in inventory.mdb without using
createObject(access.application..) which opens a separate copy of
inventory.mdb

so in system.mdb, I 'referenced' inventory.mdb and
in inventory.mdb, I created an openForm function that does
docmd.openform....

this works ok for simple forms like 'unit of measure' that have an id
& description

but if the form uses DLookup(), I get an error saying that the table
cannot be found... note... system.mdb does NOT have links to
inventory.mdb tables (and I don't really want to set them up, but...)

does anyone have any ideas on how else to do this ?