What I am trying to do:

1. user chooses variables from a form, i.e. a user, start time, end time, record type

2. run a pass-thru query that executes a SQL stored procedure that has the user's choices as parameters [the stored procedure does commands that Access is not capable of]

3. the stored procedure returns records to the form

My problem is that I haven't found a way to include the choices from the Access form as parameters in the pass-thru query.

I am a total novice at Access so it will take some time to try Chris' suggestion. Are there any other suggestions out there?