Functions -> return values

[sead]

Is this a valid code:

public Function FindIt(strTableName as string, strCriteria as string, strSearch as string) as ADODB.Recordset

' some code ...

End Function




Is it possible to return a recordset from a function or even call another sub/function like :
call MySub(rs As ADODB.RecordSet)?
If yes, how ?!?

Thanks