I would like to be able to add multiple records to a given table, based on a value on a user form (MyCopies). The below code works, but just for a adding a single record. Perhaps I am approaching it the wrong way?
Private Sub AddInstalls_Click()
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("tblInstallsAndAuths")
Let MyID = Forms!frmAddNewSoftware!SoftwareID
Let MyCopies = Forms!frmAddNewSoftware!NumCopies
.Fields("SoftwareID") = MyID
Set rs = Nothing