June7,

Can I pass it like any other variable?
Module2
Public rs as adodb.recordset
Module1
Dim rs as adodb.recordset
Create recordset
Module2.rs = rs
I tested by putting all of the code into the same module, declaring the recordset variable (rs) as Public.

Created in first sub, second sub is reporting a Rub-time Error '91': Object variable or with block variable not set.

I'll send code in a few hours, after work.

Respectfully,

-Chunk