Hi,
Consider the following code:
VB Code:
  1. Set oRs = CallMethodToGetRecordset()

  2.  Set oRs1 = oRs

  3.  Set oRs = Nothing
All along I'v been under the impression that setting oRs to Nothing within the scope would set oRs1 also to Nothing. But today I see that oRs1 has its records in place! I wondor how...

Is it something like this?
The statement "Set oRs1 = oRs" will set oRs1 to the Base Address of oRs. If I set the base address of oRs to Nothing, oRs1 is still pointing to the location with the values.

However, when I move oRs, oRs1 is also getting moved. When i close oRs, oRs1 is also getting closed!
Can some one pls explain...

- Jemima.