Passing variables to a pass-through query???

[BobLoblaws]

Currently I have a stored procedure on a MS SQL Server. I have an Access database as the front end. I am using a pass-through query to execute the stored procedure. The stored procedure requires input ( some ints, and a few datetimes).
I am having problems passing variables from a form to the pass-through query. Any ideas?

 

[tlbroadbent]

Check "How to Simulate Parameters in an SQL Pass-Through Query" at this link.

http://support.microsoft.com/support/kb/articles/Q131/5/34.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.