Can this be done with 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.

Thanks in advance.

Gary