Hi, everybody!

I have a Table which is the record source of an ADO Data Control. I'd like to refer to a field in this table using the ADO Control.
So, I've tried:
MsgBox Adodc1.Recordset.Fields.Item(2)
MsgBox Adodc1.Recordset(0)
MsgBox Adodc1.Recordset("TheFieldName")

But I always receive the following error message:
Run time error '91' - object variable or with block variable not set

so, I've taken a look into the help file and
changed my code like this:
Dim MyAdo As Object
Set MyAdo = Adodc1
MsgBox MyAdo.Recordset.Fields.Item(2)
MsgBox MyAdo.Recordset(0)

But the error message still appears!

Thanks in advance for any ideas!
Roselene