Microsoft Access new records

[Newuser26]

Hi, sorry I am new to this so please be gentle.
I work for a electronics company that buys alot of equipment in for PPE and need to keep a record of it. I have come up with a little database with 2 tables, Equipment and Equipment detail. The Equipment Table has Equipment Name and description. The Equipment Detail and Serial number and and Equipment name, There are other feilds but I don't think they are to important at the mo.
What I am trying do is, I have a text box that I put Quantity of new units in then when I press a button that number of new record are produced. So if the QTY box had 3 in it when I press the button 3 new records are put in my Equipment Detail table all with serial numbers.
Hope I have explained that ok.
Please help

 

[Newuser26]

Sorry have worked it out now, it may not be the correct way but it works !!
I used this code:

Text10.Value = Description
Units = Text3.Value

If Text3.Value > 0 Then
Me.EquipmentDetail_subform.SetFocus
DoCmd.GoToRecord , , acNewRec
EquipmentDetail_subform!Description.Value = Text10
Text3.Value = Units - 1
Command7_Click
End If