|affectrec||[optional](Long) Value specifies which records this method will affect.
1 - adAffectCurrent Affects only the current record.
2 - adAffectGroup Affects only records that satisfy the Filter setting (Filter must be set to a FilterGroupEnum value or an array of Bookmarks).
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 Recordset 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.