Nested With's -- Refer To Parent With Statement 1

[PWise]

Dim Mydb As Database
Set Mydb = CurrentDb
With Mydb.OpenRecordset("Select * from Students", dbOpenDynaset, dbSeeChanges)
    Do Until .EOF
        With Mydb.OpenRecordset("Select * from Sessions Where Studentid = " & !Studentid, dbOpenDynaset, dbSeeChanges)
            Debug.Print !StudentFirstName [COLOR=grenn]'Field in Students table[/color]
        End With
        .MoveNext
    Loop
End With

When I run this code I get this error

Item not found in this collection.

Is there some way that I can indacate that this is from the above(parent) with?

 

[PWise]

Forgot to indacate that I get the error @ this line

Debug.Print !StudentFirstName 'Field in Students table

 

[PHV]

I'd use Dim'ed DAO.Recordset objects ...