Append form Data

[paulkc]

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.

 

[HiTechCoach]

We really need more details about qry_EvaluationDetailAvg, the table and the table where you want to append to.

It might be best if you were to post a sample database.