How do I run a stored procedure from VBA code?

I have a cmd button on a form that I want to call a Stored Procedure.  I need to pass a value from a field on the form - "month" which would have values such as January 2008, February 2008, etc.  I want to pass this value to the Stored Procedure.  In the SP I use this value to populate a field in an Append function.   How do I go about writing this?

This is in Access 2007, ADP connected to SQL 2005 backend.

ThanksStart Free Trial