passing parameter to stored procedure from a form to generate report

Hi



I have an access .adp project and have a stored procedure created in sql server, I wanted to know if its possible to have an access form that takes input and when a button is clicked this runs the stored procedure where the parameter value required is what the user has input into the form and this generates a report.



Thanks

passing parameter to stored procedure from a form to generate report