Dan Waters
dwaters at usinternet.com
Thu Dec 16 20:44:15 CST 2004
I've just been testing to see if I could put a form, report, query, or table
link into a referenced library mdb. And, it works. In a standard module in
the library database I put a procedure which accepts the name of the
appropriate object as an argument, then call that procedure from the main
mdb.
For example:
Call OpenLibraryForm("frmTestForm")
In the library database is the procedure:
Public Sub OpenLibraryForm(stgFormName As String)
DoCmd.OpenForm stgFormName
End Sub
The form/report/query will open fine, just as if it was in the main mdb. I
did put a table link into the library mdb so that the objects had a data
source.
So - does anyone have experience with this practice? Any pros/cons/gotchas?
Thanks,
Dan Waters
ProMation Systems