[dba-SQLServer]Bound forms filtered on a control on the form

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





More information about the dba-SQLServer mailing list