JeroenM said:
I have a form in an Access database. When I click on a button I want to open
a particular form in a (different) particular Access Database. Is this
possible with some VBA code?
Are you sure you really need to do this? Maybe there's
another way to achieve your objective if you'll explain
**what** you are trying to accomplish instead of how you
think you need to do it.
There are two ways to open a form in another mdb. One is to
use Automation to open another instance of Access with the
other mdb.
More likely(?), you want to open the form in your current
database. In this case, you need to add the other database
to the References list in your current mdb so you can use
the its public functions. Then add a public function to
open the form to a standard module in the other mdb. There
will probably be more to it than that, such as setting the
form's record source to retrieve data from a table in the
appropriate mdb file.
