Change parameter for pass-through that execs a stored proc?

[glgcag]

I'm converting my Access database to an Access front end/SQL Server 2005 back end. I'm using ADO and I want to use pass-through queries to execute stored procedures to populate list boxes, combo boxes, forms and reports. (I'm basically using the pass-through query as the record source, which seems the easiest method.)

I have a very simple pass-through query with one parameter, which currently looks like this: EXEC sp_Test "Boat"

How do I change the parameter for the pass-through query to "Car"?

I've seen some stuff on using ADOX to change the commandtext property, but I don't want to change the actual stored procedure, just the parameter value.

Thanks for the help!