Open Form In Library Database?

[Al Aston]

I remember a magazine article (or online tip) within the last two years
about how to open a form in a library database and thereby have access to
its contents just as if I'd opened the library directly. I've searched my
pile of magazines and the Getz books but haven't been able to locate it.

(Currently in the process of breaking up a huge front-end database into
smaller chunks that will be called from an Access switchboard.)

Any ideas on where to find this info? Any "quickie" tips to get me started?

TIA

Al Aston
Arlington, TX

[Bob Hall]

I don't know how Getz et al do this, but I do it by putting a standard
module in the library, and writing a public function to open the form.

Public Function OpenSesame()
DoCmd.OpenForm <form name>
End Function

After you set a reference to the library, you can call the function
as you would any other public function.

Bob Hall
--
Access Hamsters: Free tools for users, DBAs, and developers.
Source Code: More of the same, with source code.
SQL: Solutions, troubleshooting tips, etc. for Jet & MySQL
http://users.starpower.net/rjhalljr/Serve