Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Open a Report or Form from a different database

    Is there a way I can open a report, macro, or form from a different database?

  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    Yes. The only way I know to do it is by using some VBA code. Are you familiar with VBA programming? If so, the short answer is...


    1. You want to open Form1 in DB1 from DB2


    1. Open DB2
    2. Add a reference to DB1 in Tools/References of DB2.
    3. Add a module in DB1 that opens Form1
    4. In DB2 call the procedure you created in DB1 to open Form1.

    If this is something you think would be useful to you I can provide more details. My experience has been, once you start referencing other databases within a database the number of crashes you experience will increase.

    I have a database that is nothing but code that is used by all my databases. If I have a database open that references this database, then I try to open the code database, both databases will crash. It's more of a nuisance for me since I am the programmer and the user. But if you plan to implement this for a customer it may not be as stable as you might like. I am not trying to scare you, I use this scheme everyday, but it is something to consider.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts