Access items in a RecordSet

Hi,

I have a recordset from data pulled in from SQL Server. I'm wondering how I can access specific items in that recordset?

I printed rst.RecordCount and I see there are 9 records. However, if I try to access anything larger than rst.fields(0), for example, rst.fields(1), it gives me an error saying that item is not found in this collection. How would I access the other 8 items? Thanks

There are nine records but how many fields?

rst.movenext gets you to the next record

.fields(n) refers to the nth field of the current record

So basically



You can also refer to the fields like rst![FieldName]

Dim ZdrojSQL As DAO.Recordset
Dim WantedData as Whatever
Dim i as Integer

Set ZdrojSQL = CurrentDb.OpenRecordset("SELECT * FROM SeznamTemp")

Do Until rs.EOF
i=i+1
If i=15 Then
WantedData=rs(7)
Exit Do
EndIf
rs.MoveNext
Loop

rs.Close
Set rs=Nothing