Open form from another database

[exg001@yahoo.com]

Hey all!

Here's what I want to do:

I have database A.mdb and database B.mdb. They are both using SQL
linked tables, and I am utilizing a username/password login reference
the SQL tables. Each database has its specific purpose, and each has a
main menu form which signifies what each does.

What I want, is to have a button on database A's main menu form which
will launch the main menu form of database B (as if the user started in
database B). When the user is done with database B and exits, it goes
back to database A.

I know I can "reference" an external database and get to it's modules,
but how do I open a form in the other database?

Any help would be great....thanks !

[MGFoster]

Re: Open form from another database

You have to use Automation. Read the Access VBA Help articles on
"GetObject Method" and "CreateObje ct Method" for more information.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

exg001@yahoo.co m wrote:[color=blue]
> Hey all!
>
> Here's what I want to do:
>
> I have database A.mdb and database B.mdb. They are both using SQL
> linked tables, and I am utilizing a username/password login reference
> the SQL tables. Each database has its specific purpose, and each has a
> main menu form which signifies what each does.
>
> What I want, is to have a button on database A's main menu form which
> will launch the main menu form of database B (as if the user started in
> database B). When the user is done with database B and exits, it goes
> back to database A.
>
> I know I can "reference" an external database and get to it's modules,
> but how do I open a form in the other database?
>
> Any help would be great....thanks !
>[/color]