Access 2000 and SQL Stored Procedure

I have a MS SQL 2000 stored procedure that acepts a parameter and returns a recordset.

I want to run this Stored procedure from an Access 2000 report and use the recordset for the report.

I want to pass a field off of a form that is user entered to the stored procedure.

Is this possible. Any help is appreciated.

I can figure out how to attach the stored procedure to the report as the dataset but cannot seem to figure out how to pass the dynamic parameter to the Pass-Through Query.

Thanks in advance,

Knight.