Access Fields in Sequential Order

If you know a field's name, you can access it this way:

Code:
Set fldID = recs.Fields.Item("ID") 

If you know a field's index, you can access it this way:

Code:
Set fld = recs.Fields.Item(recs.TableDesc.FieldName(7)) 

The TableDesc object stored in the Recordset's TableDesc property is used for sequential and ordered access to the fields in the table. The indexed position of the field information stored in the TableDesc matches the physical order of the fields in the table. The TableDesc class does not allow the access of a field by its name, only by its indexed position.

One common purpose for accessing fields sequentially is for populating lists and grids. To do so, you will want to use the Recordset's TableDesc property, not the Fields property.

Correct way to access the fields:

Code:
List1.Clear 
  For i = 0 to recs.TableDesc.FieldCount - 1 
  List1.AddItem recs.TableDesc.FieldName(i) 
Next i 

Incorrect way to access fields:

Code:
List1.Clear 
For Each fld In recs.Fields 
  List1.AddItem fld.Name 
Next fld

Note:
Another important difference between the Fields property and the TableDesc property in a MapLayer's Recordset is that the TableDesc references all of the fields in the attribute table. The Fields collection also references those same fields plus the 'Shape' and 'FeatureID' fields. The Fields collection will always contain two more fields than the TableDesc.