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