stored procedure and parameter pass via form to generate report (1 Viewer)

[ayh1]

Hi I have a stored procedure created in SQL SERVER 2008r2

I have a form in access adp project with combo boxes, when I click the submit button I want the values chosen to be the parameters and the stored procedure called to generate a report

is this possible

thanks

 

[richsql]

You need to use ADO, there are already posts on here I believe that can help you

search for: Execute a stored procedure from Access VBA