|affectrecords||(Long) The AffectEnum value that specifies which records this method will affect.
1 - adAffectCurrent - Affects only the current record.
2 - adAffectGroup - Affects only records that satisfy the Filter setting
The Filter property must be set to a FilterGroupEnum value or an array of Bookmarks.
The adAffectGroup value will generate an error if there are no visible records in the AdoRecordset object.
3 - adAffectAll - Affects all records if there is no Filter. Affects only visible records in the current chapter if Filter is set to a string criteria. Affect all rows of the AdoRecordset object if Filter is set to a FilterGroupEnum value or an array of Bookmarks.
4 - adAffectAllChapters - Affects all records in all child AdoRecordset objects, including those hidden by a currently applied filter.