can i rename a recordset...?

[thewiseguy]

hi there -

just wondering if this is possible...

firstly i have:
Public Dim rstRQ As Recordset, intRN As Integer

then later, could i do something like:
rstRQ.Rename = "rstRQ1"

or:
rstRQ.Rename = "rstRQ" & CStr(intRN)

thanks in advance.

 

[Mile-O]

No. Why would you want to?

 

[thewiseguy]

just experimenting...

 

[Mile-O]

You coudl do this though:

Dim rs As DAO.Recordset, rs1 As DAO.Recordset
.......
Set rs1 = rs

 

[thewiseguy]

cheers sj -

that was just what i was about to check with you...