Execute SQL Server Stored Procedure from Pass Through Query

[GrommitAPW]

I am converting an Access system to have a SQL Server Backend. For performance reasons I want to convert queries to stored procedures & run them using pass through queries. In a pass through query I am using the syntax

EXEC sp_test (5)

which works fine. However I would like to pass a value from a field on a form, instead of hard-coding the parameter in the EXEC statement. Is this possible ?

Can anybody help ?

Thanks,
Adrian

 

[hennep]

you need to change the stored query in vba:

dim qd as querydef
set qd=currentdb.querydefs("query1&quot
qd.sql="EXEC sp_test (" & me.text1 & &quot"
qd.execute

 

[GrommitAPW]

Thanks for the advice ... I'll give it a go.

Regards, Adrian