How to make multiple copies of the whole row in Access?

Question

I need to make multiple copies of the data that was entered in the row. So, I need to create a button in Access where first I'm going to select the row that I need to make copies, and when I click on the button, the message will pop out and ask to enter the number of the copies. When you enter the number, it will create the copies in that same table.

Private Sub Duplicate_Record_Click()

Dim currentID As Long
 
    If IsNull(ID) Then
        MsgBox prompt:="Enter the number of copies:", buttons:=vbExclamation
        Exit Sub
    End If

I was trying to work on code, but it doesn't work. In the picture, you can see that I was able to create the Macros that actually make single copies of the row selected, but I need it to make 20-30 copies sometimes, so I need the Message box where I would input how many copies I need. Help, please!