E
eko007
table name : products
form name : mainform
form control name : button1
form combobox name : combobox1 (binding product)
-------------------------------SP--------------------------
ALTER PROCEDURE queryproduct @whichproduct CHAR(50)
as
SELECT product
FROM products
WHERE products.product = @whichproduct
return
----------------------------------------------------------
button1 click event is..
DoCmd.OpenStoredProcedure "queryproduct"
when I click on the button1, above query is running. but how should I set
the stored procedure to get the parameter from combobox1.
thanks.
form name : mainform
form control name : button1
form combobox name : combobox1 (binding product)
-------------------------------SP--------------------------
ALTER PROCEDURE queryproduct @whichproduct CHAR(50)
as
SELECT product
FROM products
WHERE products.product = @whichproduct
return
----------------------------------------------------------
button1 click event is..
DoCmd.OpenStoredProcedure "queryproduct"
when I click on the button1, above query is running. but how should I set
the stored procedure to get the parameter from combobox1.
thanks.