I am executing a stored proc as a pass through query in sql but am having difficulty passing the parameters to the sp at run time from an Ms Access form. I have used various examples that I have found on this and other forums but am just not winning. The sp is Called upAmbledown and there are Param1 and Param2 that will get pulled from controls on the Access form. I would like to do an ADO connection on the form and then set up the connection to the query after it has executed using the params as the WHERE and then open a form called frmBusiness and set the source of the form to the connection
Your help will be appreciated.