Opening A Form In Another Database

[DLong]

Hi,
How do I use a command button to open a form that's in another database?
Thanks in advance.

[TonyES]

Hi,
You can define the other database as a reference in the first database (Alt-F11 in the first database, go to Tools | References..., click the Browse button, change the "Files of type" dropdown to "Microsoft Office Access Databases", and find the other database). Once you set the other database as a reference, in the first database you have to call a public subroutine that is in the other database (no special syntax - it will look there as well as your current database once the reference is set). That public subroutine will open the form that you want in the other database.

Using Automation, you could do this:

Dim app As New Access.Application
app.OpenCurrentDatabase "OtherDatabase.mdb"
app.DoCmd.OpenForm "frmSomething"
app.Visible = True
Set app = Nothing

Cheers!

[DLong]

Thanks a lot, I will check it and will let you know.