Access 2003 .adp: How to include parameter in OpenStoredProcedure

E

Eaton

Hi,

I'm using Access 2003 .adp.
I'm trying to used the DoCmd.OpenStoredProcedure and pass a string paramter
like: DoCmd.OpenStoredProcedure "spXYZ 'parm1". When I specify just the
procedure name and omit the parameter, it prompts me for the paramter, which
I fill in and then it runs correctly. I don't want the prompt.
This is different than the InputParamter property for a form.
There's got to be a way to specify the parameter in VBA so the user is not
prompted for it.
Any ideas?

Thanks!
 
Top