Open form in another database

[TD]

Is it possible to have a command button on a form that will open another
form in a complete different mdb database?

Thanks,

 

[Arvin Meyer [MVP]]

Not without opening the other database first. You can open a form from
another database in your current one, by writing a standard module piece of
code, then setting a reference to the other database in your current one:

First Database:
Public Sub OpenContractors()
DoCmd.OpenForm "frmContractors"
End Sub

Set a reference to First Database
(From any code window: Tools ... References):

Second Database
Command button:

Private Sub cmdOpenContractors_Click()
OpenContractors
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access