Class Objects HELP!!

[JC1122]

First off, Thanks for helping!!!

I have a class, in which i have two public functions.

One says:
Public Function connect() As Connection
If blSQL And blPWD And blDB And blUser Then
With cn
.ConnectionString = "BLAH"
.Open
End With
Set connect = cn
End If
End Function

The other says:
Public Function Source(ByVal SourceString) As Recordset
With rs
.CursorLocation = adUseClient
.Source = SourceString
.Open , cn
End With
Set Source = rs
End Function

I do a
cn.connect
cn.source = "Query"

DOES ANYONE KNOW HOW TO ACCESS THE RECORDSET INFO?!?

i can't do a cn! because it's not set up to access that info because I DON'T KNOW HOW

Any help would TRULY be appreciated!!!

Thanks again!!

JC

[shunt]

I don't understand. What do you mean

access the recordset info

Do you mean the data in the recordset.

set rs = cn.Source("sql select")
 
If Not rs.eof Then
    Msgbox rs.fields(0).value
Else
    Msgbox "no Data found"
End If

[JC1122]

Thank you!!

Something as trivial as that...ok, I don't know what I was thinking but thank you VERY MUCH!!

JC

[shunt]

no problem