I created an access .adp database and have it linked to SQL server. I have a stored procedure in SQL called spSelectMyAction which has a variable @GetAction. I would like to pass a variable from an access form (Form_employee.cboaction) to SQL, run the stored procedure and have it populate the recordsource on a form.
In the most basic form which doesn't work, I want this:
Me.recordsouce = EXEC spSelectMyAction "cboaction"
Anyone know the correct syntax?