Hey Cesar,

It is not possible to do this graphically with SQL Server using Access
projects.  The Access 2000 query designer for SQL Server 7 does not support
parameters for views.  You can do it with code however.  One way to do this
is by passing one or more parameter values from the form to a SQL Server
stored procedure.  An event procedure can help you do this.  My book,
Professional SQL Server Development with Access 2000, has a sample of this
approach to the problem as well as another approach to the problem on pages
382-386.

Rick Dobson
www.programmingmsaccess.com
www.cabinc.net
rickd@c... <mailto:rickd@c...>



Subject: Access Forms and SQL
From: "Cesar Henao" <millos21@h...>
Date: Mon, 5 Feb 2001 17:00:48 -0000
X-Message-Number: 5

I am transfering my existing Access 2000 database to and SQL back end and
using Access Projects as my front end.

In access 2000 I hade a query which would pull the criteria in reference
to a form, eg:

ID#
[Forms]![FormName]![ID#]

Can I do this in SQL 7.0 using a view or a stored procedure?
I want to be able to reference my criteria, back to a form.

Thanks in advance,

Cesar Henao