Cannot Instantiate child recordset

[cpod]

I am trying to open a child recordset but keep getting Error 424 "Object required".

Dim rstEmails As DAO.Recordset2, DBS As DAO.Database, rstFile As DAO.Recordset2
Set DBS = CurrentDb
Set rstEmails = DBS.OpenRecordset("Beldenemails")
Set rstFile = rstEmails.Fields("email").Value 'Error 424 here
End Sub

I've tried everything I can think of. Does anyone have any ideas for me?

 

[rzw0wr]

Dim rstEMails as DAo.Recordset
Dim rstFile as DAO.Recordset
Dim DBS as DAO.Database

Set DBS = currentDB

Set rstEmails = DBS.OpenRecordset("Beldenemails")
SET rsFile=DBS.OpenRecordset("PutSomeTable/QueryHere")

Close rstEmails
Close rstFile
Close DBS
Set rstEmails=Nothing
Set rstFile = Nothing

The fields property refers to ALL of the fields. An array. Field(1).....Field("email")....
No need to set it.
rstFile is a recordset in memory not a field.

What are you wanting to do?

Dale

 

[SOS]

Your declarations are wrong.


Dim rstEmails As DAO.Recordset2, DBS As DAO.Database, rstFile As DAO.Recordset2

Should be


Dim rstEmails As DAO.Recordset, DBS As DAO.Database, rstFile As DAO.Recordset2

The first one uses the Recordset object and the sub recordset uses Recordset2.

 

[cpod]

Sorry. Still doesn't work.

 

[SOS]

Sorry. Still doesn't work.

You are using it to get multi-valued field values, are you not? It isn't just for anything. Can you explain more about what it is you are doing?

EDIT: Oh, and you are using this in an ACCDB file, correct?