I have a stored procedure that is run by a query in a MS Access ADP. When I run the query, I get a combobox where I can enter the parameter value. If I click on the drop down I have the option to select <DEFAULT> or <NULL>. I know I can add a default value. What I would like to do is have 2 or 3 options in the drop down for the user to select from. Is this possible? I've been searching for an answer, but maybe I'm not phrasing my searches correctly.
For the parameter @Cont, I'd like to have 2 or 3 options in the drop down box for the user to select. This would save me from having to have 2 or 3 separate queries.
Here's my stored procedure:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
ALTER PROCEDURE [dbo].[BL_GetCont]
-- Add the parameters for the stored procedure here
@Date varchar (10)
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
WHERE [Cont] LIKE '%' + @Cont + '%'
AND [BDAT] > = @Date