Populate a file using a query in the background after insert

[lindaF123]

This SQL statement works perfectly when I run alone, it requests the input parameter. I want to pass the value in as the value on the form... but when I run it from an after insert event.... telling it to use [Forms]![StudentCourses]![CourseNo] in where statement... it doesnt work.



The statement won't run at all ... please can you help....


Private Sub Form_AfterInsert()

CurrentDb.Execute "INSERT INTO StudentComponents ( ComponentID, courseNo, rectype, StudentID, StuCourseID )" & _
" SELECT Components.ComponentID, Courses.courseNo, 'C' AS rectype, StudentCourses.StudentID, StudentCourses.StuCourseID" & _
" FROM (Coursetypes INNER JOIN (Components INNER JOIN Coursecomponents ON Components.ComponentID = Coursecomponents.ComponentID) ON Coursetypes.courseID = Coursecomponents.CourseID) INNER JOIN (Courses INNER JOIN StudentCourses ON Courses.courseNo = StudentCourses.CourseNo) ON Coursetypes.courseID = Courses.courseID" & _
" WHERE (((Courses.courseNo)=[Forms]![StudentCourses]![CourseNo]));"

End Sub

[orange]

it doesnt work.

isn't very helpful.
I note that this is your first post. It is always helpful to readers if you describe what you are trying to do in simple English.
Talk to us as you would to an 8 year old so we get some understanding of the "business". Add details as necessary to clarify any steps you have taken to get to the point you are at. Avoid jargon and acronyms.

Is this your first database? Can you post a jpg of your tables and relationships?
Why did you choose the event you are using? etc. etc.

Welcome and good luck with your project.

[NTC]

I interpret your post in that you are working on a sql statement (which you posted). Have you instead attempted to make this query work using the query design view? If not I would suggest that path first - and then put it into SQL View in order to see the sql statement.