I have an access project which connectes to a sql database.
I want to create a texbox in my report that calls a stored procedure that takes two parameters and returns a value and I want the text box to show the result value from the store procedure. Does anyone know how to do this.. or if it is even possible?
EX. // I tried placing the code below in the control source of the text box
sp_TEST 'X', <VALUE FROM ANOTHER TEXTBOX>
I want to create a texbox in my report that calls a stored procedure that takes two parameters and returns a value and I want the text box to show the result value from the store procedure. Does anyone know how to do this.. or if it is even possible?
EX. // I tried placing the code below in the control source of the text box
sp_TEST 'X', <VALUE FROM ANOTHER TEXTBOX>
