Stored Procedure Query

[JohnITD]

Hi all,

Quick question regarding queries. Im working on a project in Access 2002. I want to execute a stored procedure as a SQL Pass-Through Query and pass a variable to it from my code.

Im guessing the statment will look something like this:

exec get_companylist_search @variable

I have tried this but it appears exactly as it is typed in SQL profiler.

Any ideas?

Cheers
John