How are ya patyavila . . .
Yes you can but you'll need code in the external db to open the form as it can't be done directly. [blue]Basically you'll be setting the external db as a library reference in the current db.[/blue] What this does is make all modules in the modules windows available along with their subs and functions. As a library these are now available to you for direct use. You can even see them in the Object Browser! [blue]Just be aware of functions & subs in both db's which may have the same name.[/blue]
[purple]Note: the following doesn't take into account any conflicts that may arise from the shared tables or multiuser operations of either db . . . if any![/purple]
[ol][li] In a module in the modules window of the [blue]external db[/blue] (the one that holds the form), copy/paste the following routine:
Code:
[blue]Public Sub OpenExtFrm(frmName As String)
DoCmd.OpenForm frmName
End Sub[/blue]
[/li]
[li]Save & Close the external db.[/li]
[li]Open the [blue]calling db[/blue] and navigate your way to the [blue]VBE editor[/blue].[/li]
[li]Then [blue]Tools[/blue] - [blue]References[/blue]. Click the [blue]Browse[/blue] button then navigate your way too and select the [blue]external db file[/blue] (don't forget to select file type of mdb).[/li]
[li]The db should now appear in the References listing with a check mark.[/li]
[li]Click OK and your set.[/li][/ol]
Now to open any form in the external db:
Code:
[blue] OpenExtFrm("[purple][b]ExternalFormName[/b][/purple]")[/blue]
[purple]Note: the code doesn't check if the form exist.[/purple]
Thats it . . . let me know how ya make out . . .
See Ya! . . . . . .