Stored Procedures are great.. I use them for most operations in Access Data Projects.
What is so beautiful about Access Data Projects? It auto-resolves parameters to controls on the form!!! If your sproc has a parameter called @txtStartDate, then if you set the recordSource of the control to the Stored Procedure name, then it will automatically resolve any parameters to the names of controls on the form.