Question Calling Form and Report in a .mda file

[oldes]

Hi ,

I would like to know that if it is possinle to call Forms and Reports which are in a .mda file.

İf it is possible is there a sample code which I can refere to

Thanks

 

[apr pillai]

When you call a Function from the Library File and if that function opens a Form or Report, it will look for the Form/Report in the Library database itself first and opens it from there if found.

If the Form/Report not found within the library file then it will look for it in the Current database where the library file is attached.

You can attach an .mda file to the current database and call the functions in that file as if they are in the current database.

1. Open VBA Window of the current database (ALT+F11).
2. Select References... from Tools Menu.
3. Browse for your .mda file on disk and attach it.
   
4. Read the following blog post for details:MS-Access and Reference Library