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

From: Alex Dybenko (
Date: 07/08/04

Date: Thu, 8 Jul 2021 11:13:37 +0400

Probably you have both ADO and DAO references? try to declare recordsets
explicity as:
set rst=DAO.recordset
set rst=ADODB.recordset

Alex Dybenko (MVP)
"JingleBEV" <> wrote in message
> 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
>  mismatch).
>  how can I achieve it?
>  Your help is appreciated.
>  Jing.