dao and sql procedures

[Guest_imported]

How do you call a sp that return value(s) using DAO.
I checked msofts site and found this:

the sqlstr builds the stored procedure with the passed in vars

the connection is valid also

--------------------------------------------------
Dim rstTest As Recordset
Dim test

Set rstTest = Connection.OpenRecordset(sqlstr, dbOpenSnapshot, dbSQLPassThrough)
-------------------------------------------------

when i try this, i get an "invalid argument error"

 

[bluenote]

try filling sqlstr with the same command that you use to execute SP's on your db engine

:-I bluenote@uyuyuy.com
(excuse my english)