никогда не интересовался
на скорую руку
могу предложить
DoCmd.GoToRecord , , acNewRec
если будет ошибка
то ее перехвати
извиняйте, что не шибко-
отвечаю по сутИ.

RecordsetType возвращает
не то что нужно

MsgBox [пф Контрагенты].Form.Recordset.Supports(adUpdate)
тоже возвращает True
а на самом деле необновляемый

шкет и шайтан
вы хоть проверяете то,
что советуете?
если вы про это

RecordsetType Property
See Also Applies To Example Specifics
You can use the RecordsetType property to specify what kind of recordset is made available to a form. Read/write.

expression.RecordsetType

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks
The RecordsetType property uses the following settings in a Microsoft Access database (.mdb).

Setting Visual Basic Description
Dynaset 0 (Default) You can edit bound controls based on a single table or tables with a one-to-one relationship. For controls bound to fields based on tables with a one-to-many relationship, you can't edit data from the join field on the "one" side of the relationship unless cascade update is enabled between the tables. For more information, see the topic that explains when you can update records from a query.
Dynaset (Inconsistent Updates) 1 All tables and controls bound to their fields can be edited.
Snapshot 2 No tables or the controls bound to their fields can be edited.

If you don't want data in bound controls to be edited when a form is in Form view or Datasheet view, you can set the RecordsetType property to Snapshot.
The RecordsetType property uses the following settings in a Microsoft Access project (.adp).

Setting Visual Basic Description
Snapshot 3 No tables or the controls bound to their fields can be edited.
Updatable Snapshot 4 (Default) All tables and controls bound to their fields can be edited.


то выдает все время 4
а набор-то необновляемый