Hello,

I have a stored proc with several inputparameters.
I created an Access project file with Access2003
I would like to use the output recordset of the stored proc in a subform.
I wrote code to collect the parameter values from a form. In code I specify the recordsource property of the subform as the stored proc name and the inputparameters property to the parameters.
As help describes I use the following syntax for the inputparameters property: @param1 char='aa', @param2 int=2...

Help says that if I want to use DEFAULT value for a parameter (which is defined in the stored proc), I can simply ommit that parameter from the forms' inputparameters property.
It is works until the stored proc is "simple", but sometimes Access passess NULL-s to SQL server for the missing parameters. (I checked this with profiler.)
I realized if Access is not allow the create an "Autoform" based on a stored proc, than the inputparameters property is not working properly for that stored proc.

Is it by design? )

Thank you for your help, Gábor