How can I call (Open) a diff dB's form from current dB ???

[Dylan]

I would like to simplify our environment which contains multiple dB with a Menu dB that will simply call another dB and open a specific form within that called dB.

I have gotten th dB to open OK with a call statement, but I cannot figure out how to tell it to open a specific form. I cannot use the startup option because I want to be able to open different forms.

Heres whta Imean :

The Menu dB = dbA.mdb

This dB needs a command button to call dbX.mdb and open form frm1

This dB also a command button to call dbX.mdb and open form frm2

Thanks for any help ...

 

[MichaelRed]

Verrrrrryyy Interrrresting.

Never done this, however I THINK you COULD do it in a VERY awkward manner.

In SOME db (I will refer to it as "Mstr", include a table (Refer to as "MstrForms" with each of the other dbs as one col, and the desired form (name) in another.

[tab]TargetDb[tab]TargetFrm
[tab]dbA[tab]frm2
[tab]dbd[tab]frmX

In each of the dbs which opens one of the others, when/if you know what form to open, place the name of the form in the table.

e.g To set the "opening form" for Dbd,
[tab]open the table as a record set
[tab]Find the entry for "dbd"
[tab]Set dbs!TargetFrm = "frmX"


In each of the 'slave' dbs's, (dba | dbb | dbc | ... | dbx)include a "splash screen", which is (of course) the startup form for the db. In that form (splash screen), include the code to retrieve the name of the form to open from the "Mstr" db, and have your code open it on exit of the splash screen.

Hopefully, someone can provide an easier approach.

A variant (PUN Intended) on the approach would be to set the info into the registry, instead of a plain vanillia MDB file.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over