Hi Guys,
I'm in desparate need of help. I am producing a database for my dissertation and have got majorly stuck. I am currently creating a form in which the user will select a student from a combo box, which that selection populates the next combo for the course selection. I have managed to do that with the coding shown below, my next combo will work from the course selection to bring back the feedback topics associated with that course, that there brings back one of my issues. Using the methods below i.e.queries, etc i cannot work out how to cross-reference one table to another using the results from the 2nd combo.
1st Combo Selection
Query
qryStudent
Select DISTINCT CoursesTakenbyS tudent.StudentI D
FROM CoursesTakenbyS tudent
ORDER BY CoursesTakenbyS tudent.StudentI D;
Row Source
SELECT DISTINCTROW [qryStudent].[StudentID]
FROM [qryStudent];
After Update
Private Sub cboStudent_Afte rUpdate()
Me!cboCourse = Null
Me!cboCourse.Re query
End Sub
2nd Combo Selection
Query
qryCourse
SELECT DISTINCT CoursesTakenbyS tudent.CourseCo de
FROM CoursesTakenbyS tudent
WHERE (((CoursesTaken byStudent.Stude ntID)=[Forms]![StudentFeedback]![cboStudent]))
ORDER BY CoursesTakenbyS tudent.CourseCo de;
Row Source
SELECT DISTINCTROW [qryCourse].[CourseCode]
FROM [qryCourse];
After Update
Private Sub cboCourse_After Update()
Here is the table structure i have in place:
tbl CourseTakenbySt udent
StudentID (pk)
CourseCode (pk)
These two tables are joined through a table Course via CourseCode.
tbl CourseFeedbackT opics
CourseCode (pk)
TitleID (pk)
If anyone could help it would be gratefully receieved.
Many Thanks
Didihynes