Mike and Doris Manning
mikedorism at ntelos.net
Tue Feb 25 16:27:33 CST 2003
Pass that records identifier to the sproc as an Input Parameter. If you have ADH2000, volume 2 has a lot of information about using Access with SQL Server. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of John W. Colby Sent: Tuesday, February 25, 2003 04:53 PM To: AccessD-SQLServer Subject: [dba-SQLServer]Bound forms filtered on a control on the form I have been following the thread on the report thing. The discussion has focused (the ones I have read) on using XP, where there are actually properties to do this. How do I do this in A2K? I have a form. I want to select a record in a combo box. Having selected that record, I want to run an sproc, passing a parameter to filter the data returned to only return the record selected in the combo box. How do I do that in A2K? John W. Colby Colby Consulting www.ColbyConsulting.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com