Charlotte Foust
cfoust at infostatsystems.com
Wed Apr 12 14:50:00 CDT 2006
You can't do that. SQL Server knows absolutely nothing about Access forms, even in an ADP. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Johncliviger at aol.com Sent: Wednesday, April 12, 2006 10:44 AM To: accessD at databaseadvisors.com Subject: [AccessD] Upsizing AXP to SQL2000 Hi I'm upsizing AXP to SQL 2000 and the new front end is ADP. And I have form with 2 subforms. To populate one of the subforms I use an In-Line query with the following reference in the criteria column = @Forms_Purchasers_Subform_Form_OrderDetailID But at run time I get a parameter popup dialog box with showing " Forms_Purchasers_Subform_Form_" I've search KB but to no avail. Anyone know a KB article on this subject? TIA johnc -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com