How to register the first element of the list in the event procedure?

Question

Microsoft Access

In the marks table, you must specify the student id, the id of the assessment criterion, and the assessment itself. I wrote the following in the "Save marks" button:
Dim strSQL, gradeSQL As String
strSQL = " Insert Into marks(criteriaid, userid, finalgrade) values ​​('" & Me.criteria & "', '" & Me.student & "', '" & Me.mark & ​​"');"
CurrentProject.Connection.Execute(strSQL)
MsgBox("Added!").
The problem is that one record will be added to the table, but you need to duplicate the student id and add the rest of the grades.

Answer 1

Well, you have values ​​in insert for only one row, what do you want. So screw the cycle.