John W. Colby
jwcolby at colbyconsulting.com
Sat Sep 4 12:45:49 CDT 2004
Paul, One way to do this is to reference the database (set a reference to it), then build a function in the database that opens a form. Now call that function, passing the name of the form to open. Be aware however that if the form is bound it will try to bind to a table in that database, so if your intention is to use that form to display data in the current db you will need to late bind the form. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Rodgers Sent: Friday, September 03, 2004 10:01 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Open a form from a different db I need to open a form from another database. I just can't find it in my books. Anyone done this simple thing recently please? Cheers paul --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com