Parameter query?

[Jay]

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

Many thanks.....Jason

 

[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.