I have a stored procedure on SQLServer which requires a variable. This variable is the contents of a textbox on a form. I have tried many ways to do this (in code and a pass-through query but nothing works.
This is the contents of my ps query:-
EXEC procMyProc '" & Forms!myRef & "'"
Can anyone show me how to do this in either code with querydefs or in a ps query. BTW RRR has been trying to help me - Thanks RRR but I'm still struggling.