RecordSet.IdxField

Method

RecordSet.IdxField ( Index as Integer ) As DatabaseField

Returns the DatabaseField for the record specified by index in the RecordSet. index is 1-based.

Example

Get the string value of a column in a RecordSet:

// rs is a RecordSet; column 1 is a string column
Dim productName As String
productName = rs.IdxField(1).StringValue

Set the string value of a column in a RecordSet:

// rs is a RecordSet; column 1 is a string column
rs.Edit
rs.IdxField(1).StringValue = "Generic Widgets"
rs.Update