Open form in another database

T

TD

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

Thanks,
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening form unexpectedly closes other form 0
Access Access Report Works on One Machine but not Another 3
Opening a sub-form from a command button 1
1 form data from different database 1
form load in accdb is slower than in mdb 1
Access Command to run access, open to specific form and specific record 1
Separate Form 0
Access how to open existing database from another database using Access - VBA 0

Top