cRecord.AddField

AddField

returns cField

accepts (fieldName as String, FieldValue as Variant, Optional FieldOrder as Variant)

If the record does not have a field with the supplied fieldName, then a cField object is created and added to the cRecord.

If the fieldName does already exist the method appends a sequential number to the end of the supplied fieldName and inserts the field with that name. The method will increase the number until it finds an unused field name and the field will be added.

If the optional FieldOrder parameter is present the new field will be placed in the ordinal position supplied as according to the cRecord.SetFieldOrder method.