how to use where in access

[sql]

SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, ReorderLevel, Discontinued
FROM Products
WHERE CategoryID=@CategoryID I got error on where clause, what is wrong
using access(aspnet data set)
________
FORD XC FALCON

[rmiao]

How did you assign value to @CategoryID?

[Island1]

The error message itself might be useful, too ...

Thanks,.

Bill