how to pass recordset object to procedures/functions?

Hi all,
I am trying not to use global variable to maintain data consistency. Some
procedures and functions will require to pass the recordset object for
processing and functions may also return the recordset object to the calling
functions/procedures. I already tried this but keep getting error 13 (type
mismatch).
how can I achieve it?

Your help is appreciated.

Jing.

re: how to pass recordset object to procedures/functions?

We need to see the *exact* code you're trying to use and getting the error
with.

--

Randy Birch
MVP Visual Basic
http://vbnet.mvps.org/
Please respond only to the newsgroups so all can benefit.


"JingleBEV" <n_quan@NOSPAMyahoo.com> wrote in message
news:jw2Hc.31301$WM5.1417197@news20.bellglobal.com ...
: Hi all,
: I am trying not to use global variable to maintain data consistency. Some
: procedures and functions will require to pass the recordset object for
: processing and functions may also return the recordset object to the
calling
: functions/procedures. I already tried this but keep getting error 13 (type
: mismatch).
: how can I achieve it?
:
: Your help is appreciated.
:
: Jing.
:
:

re: how to pass recordset object to procedures/functions?

Function Process(rs as ADODB.Recordset)
'....
'works for me..
'
End Function

"JingleBEV" <n_quan@NOSPAMyahoo.com> wrote in message
news:jw2Hc.31301$WM5.1417197@news20.bellglobal.com ...[color=blue]
> Hi all,
> I am trying not to use global variable to maintain data consistency. Some
> procedures and functions will require to pass the recordset object for
> processing and functions may also return the recordset object to the[/color]
calling[color=blue]
> functions/procedures. I already tried this but keep getting error 13 (type
> mismatch).
> how can I achieve it?
>
> Your help is appreciated.
>
> Jing.
>
>[/color]