Parameter query?

J

Jay

Is it possible to have a parameter user-prompt in an .adp stored proc or
query? (and if so....how?)

Many thanks.....Jason
 
T

Tom van Stiphout

It's quite unconventional, but yes it is possible.
Set inputparameters property for your form to something like:
@CatID=[Which CatID would you like to see:]

and have a sproc like this:
create procedure CategoriesByCatID
(@CatID int)
as
select * from Categories
where CategoryID=@CatID

-Tom.
 
Top