Execute stored procedure with form variables in Access 2003

[nowandever29]

Hi,

I'm creating an Access 2003 "page" (web page) in an ADP attached to SQL Server 2000. I have a form with rows on it, and I need to do two things:

First, I need to call a number of stored procedures I have in SQL - how can I do that via an Access page?

Second, I need to pass the value of a form field to the stored procedures. This might be tricky, I don't know, because the page has a group by format, listing multiple records - in design view, there is only one field. But on the web page, that field is replicated for each row in the table.

Please help, answers to either or both questions are much appreciated!!!

Thanks,
Nowandever29