Stored procedure is recordsource for form and should return a parameter. How?

[furkat]

Hi All

one of my forms is based on the results of stored procedure (that is
Form.RecordSource="exec MySP")
MySP has an output parameter as well. How can I get this parameter from this
stored procedure? I can't call it twice as output parameter can change...

Thanks

Furkat

 

[Mary Chipman]

Re-write the stored procedure's output parameter value as an
additional column in the SELECT statement. You['ll get the value in
every row in the result set, but you don't need to display it in a
control on the form. Access forms aren't designed to handle output
parameter values.

--Mary

 

[furkat]

Thanks,
it works...
Furkat

Re-write the stored procedure's output parameter value as an
additional column in the SELECT statement. You['ll get the value in
every row in the result set, but you don't need to display it in a
control on the form. Access forms aren't designed to handle output
parameter values.

--Mary

Hi All

one of my forms is based on the results of stored procedure (that is
Form.RecordSource="exec MySP")
MySP has an output parameter as well. How can I get this parameter from this
stored procedure? I can't call it twice as output parameter can change...

Thanks

Furkat