The Field object allows you to work with the fields in a record. The Fields collection contains all of the fields in a record.
You can retrieve a field from the Fields collection with the Item property by the number associated with the field.
{Retrieve the first field from the record.}
recordField = recordset.Fields.Item[0];
You can also access fields by the field name.
{Retrieve the field named "BuyerID".}
recordField = recordset.Fields.Item["BuyerID"];
Use the Value property to retrieve the value of a field in a record. The property returns the field value of the record that the recordset is currently pointing to.
{Retrieve the value of the first field in the last record.}
recordset.MoveLast();
fieldValue = recordset.Fields.Item[0].Value;
You can also use the Value property to set the value of a field.
{Set the value of the BuyerID field in the next record.}
recordset.MoveNext();
recordset.Fields.Item[0].Value = 'Buyer ID';
recordset.Update();