passing parameter to stored procedure from a form to generate report (1 Viewer)

[ayh1]

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