Can this be done using SQL 7?

[Gary McGowan]

I am using SQL 7 with Access 2000. Can someone please tell me how to pass the value from a bound combo box on an Access Project form to the following stored procedure:

Alter PROCEDURE usp_Find_Order
@VendorID varchar(255)
AS
SELECT * FROM ViewItems WHERE
VendorID= @VendorID

This procedure is the Row Source for the combo box.

Gary

[John Wilson]

Nooooooooooo!!!!!!!!

------------
Gary McGowan at 9/3/99 1:24:07 PM

I am using SQL 7 with Access 2000. Can someone please tell me how to pass the value from a bound combo box on an Access Project form to the following stored procedure:

Alter PROCEDURE usp_Find_Order
@VendorID varchar(255)
AS
SELECT * FROM ViewItems WHERE
VendorID= @VendorID

This procedure is the Row Source for the combo box.

Gary