You need a macro that will add entries to the "00_tb1_org" table.

It is necessary that the value of the record from the counter "from" - "to" is substituted in the "tb1_id" field.
Those. if the counter is c = 1; po = 3
then in the field "tb1_id" the value is substituted: 1, 2, 3.

If the counter is with = 4; = 6, then in the "tb1_id" field the value is substituted: 4, 5, 6.

The remaining fields are substituted for the same type values.
Those. if the form is filled in:
c = 1;
po = 3;
tb1_OrgName = tb1_OrgName value 1;
tb1_xar1 = tb1_xar1 value 1;
tb1_xar2 = tb1_xar2 value 1;

then three entries will be created.
The screen shows the result for two options. enter image description here

Began to try, but something gives errors

Private Sub Кнопка14_Click() Dim Rst As DAO.Recordset Set Rst = CurrentDb.OpenRecordset("00_tb1_org") Rst.AddNew Rst.tb1_xar1 = tb1_xar1 Rst.tb1_xar2 = tb1_xar2 Rst.Update Rst.Close Me.fmSingleQuestionMode.Requery End Sub 

Link to the file http://transfiles.ru/gl55e

  • one
    for i = с to по : rst.addnew : ... : rst.update : next i : rst.close - Akina
  • @Akina Thanks for the reply. Works. I did something like that, but I can understand how to make the text climb out of the form fields, not from the code, as in the code in my message .. Probably make out as an answer. Dim i As Long With Me. Recordset For i = Val (Me.start) To Val (Me.finis) .AddNew! Tb1_id = i! Tb1_OrgName = "Îðã" & i! Tb1_xar1 = "ðã" & i & "ðð 1 . " & i! tb1_xar2 = "Îðã" & i & "Õàð 2." & i .Update Next End With Me .Requery - koverflow

0