marku24
asked on
Access ADP recordsource to SQL server
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?
In the most basic form which doesn't work, I want this:
Me.recordsouce = EXEC spSelectMyAction "cboaction"
Anyone know the correct syntax?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER