Thank you so much. I believe that solved the problem.

I didn't even think about trying a QueryDef

Thanks for all of the help.

Tracy Ramirez

If it is not possible to run a pass-through query as:

Exec UpdateInfo @EmpID = MyVariable

and you have to state exactly

Exec UpdateInfo @EmpID = '4321'

How would you pass a value (that's...

I'm sorry I misunderstood your ?. No I did not execute that string exactly. I will try that.

But I do know in access when I tried to remove @MedRecNum...

From my form in access in the after update event I am firing this pass-through query.With the following code.

docmd.RunQuery "UpdateInfo"

This is the code for the pass-through query.

Exec UpdateInfo @EmpID =...

I'm sorry to be such a bother and I appreciate all of your help this far.

I did try that and I do get a value 3526

but when I move this...

Thank you

Your correct my stored procedure is working properly now. (Sorry I thought it was working before since it didn't give any errors).

So now my pass-through query says:

Exec UpdateInfo @EmpID...

Stored Procedure (This works)

CREATE PROC UpdateInfo @EmpID VARCHAR(10)

AS

IF CHARINDEX(CHAR(37), @EmpID) > 0

BEGIN

DECLARE @sql NVARCHAR(2000)

SET @sql = SELECT * FROM tblEmployee WHERE EmpID LIKE @EmpID

EXECUTE sp_executesql @sql

END

ELSE

BEGIN...

Hello jPipes

Your suggestion worked, however, from access I still have to specify the exact EmpID I'm working with.

Exec UpdateInfo @EmpId = '1234'

I have tried the other suggestions, but still unable...

Thank you for your help.

Please forgive me for asking another ? (I'm a beginner)

This is going to work, however in my pass-through query in access I want to say

Exec UpdateInfo...