Congratulations! Its a bouncing baby pass-through query!

[microsoft]

Its been a hell of a day for reasons other than MS and that damndable
Ribbon.

I have a stored procedure that I'm now able to access via a pass-through
query. How would I go about altering the parameters passed? Do I need to
create a module that creates the querydef on the fly dynamically added the
actual values or are there other ways?

 

[Douglas J. Steele]

You need to alter the SQL of the query dynamically.

 

[David C. Holley]

Yeah, I thought so.

You need to alter the SQL of the query dynamically.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

 

[David C. Holley]

Actually I was surprised at how easy it was to create a create/update sub to
mange it. Quite nice.