This will be an easy one for you ACCESS guru's I am sure. I have built an application in ACCESS2000 and a backend in SQL 2000. I have a main form with many subforms that I am asking for user input with. When they enter the data it is stored in a few different tables in SQL. I then have a submit(command button)button on the form for the user to push once they have entered all the desired codes.
What I am trying to do is run a stored procedure residing on SQL server that will use the results from the tables as parameters against the main tables. So my real question is - what do I code in the access code for the command button that will call the stored procedure in SQL2000?

Thanks for the help.
BS

Not trying to be mean - But did I ask a really hard question? I don't know half as much as most on here about ACCESS, but I did not think it was a really hard question. If it is just let me know so I will know to seek knowledge somewhere else?

Thanks,
Brian