I have a form [frm_EvaluationDetailAvg] which is displaying data from the query [qry_EvaluationDetailAvg] in a continuous form. I would like to append the data that is showing in this form to a table [tbl_AccumulatedMeritPoints] but I also want each record to include data from another form [frm_Start/End Input] which gives some criteria for the query. I have accomplished something similar to this using the following code:
<Dim sql As String
sql = "INSERT INTO EvaluationDetails ( EvaluationID, StudentID ) " & _
"SELECT " & ID.Value & " AS EvaluationID, user_id " & _
"FROM ActiveStudentList;"
CurrentDb.Execute sql
/>
I'm just not sure how to modify it for this application.
<Dim sql As String
sql = "INSERT INTO EvaluationDetails ( EvaluationID, StudentID ) " & _
"SELECT " & ID.Value & " AS EvaluationID, user_id " & _
"FROM ActiveStudentList;"
CurrentDb.Execute sql
/>
I'm just not sure how to modify it for this application.