Pull Value from From Using Append Query

[kedstracker]

I have two tables, Curriculum and Coursework Completed. Using a form based on the Coursework Completed table, that is already filtered to show a student's data, I am trying to add an Append Query so that when a curriculum is selected for a student, the required courses for that curriculum are pulled from the Curriculum Table and entered into the Coursework Completed Table. I can get this to work, but what I can't figure out is how to have the Student ID that is showing on the current record on the form be included and entered into the Coursework Completed Table as part of the Append Query. The student ID on the form is linked to the value from another table with the student's information. The Coursework Completed Table will not contain the Student ID until after the Append Query is run.

These are the fields in each table/form:
Curriculum Table: Curriculum, Course #
Coursework Completed Table: Student ID, Curriculum, Course #
Coursework Completed Form: Student ID, Curriculum, Course #
Student Table: Student ID



The Curriculum and Coursework Completed Tables are related by the curriculum field.

[TheShabz]

Not sure this is exactly what you want but if the student ID is displayed on the form, you can reference its value in a query with Forms!formName!controlName

Also, just some housekeeping things, if at all possible, remove spaces and special characters (!@#$%^) from your table and field names. Makes life much easier.