Notes ListBox

[KodeKing]

Hi all,

I am having a problem getting the notes on a student to display. At the moment I have to input the student ID into an input box before the students for displays or I don't get any notes displayed.

This is what I have in the SQL statement for my ListBox.

SELECT tblNotes.NoteID, tblNotes.StudentID, tblNotes.Date, tblNotes.Author, tblNotes.Note, tblStudent.StudentID
FROM tblStudent, tblNotes
WHERE tblNotes.StudentID = tblStudents.StudentID;

This is for a college project and any help would be great! Thanks

 

[reclusivemonkey]

SELECT tblNotes.NoteID, tblNotes.StudentID, tblNotes.Date, tblNotes.Author, tblNotes.Note, tblStudent.StudentID
FROM tblStudent, tblNotes
WHERE tblNotes.StudentID = tblStudents.StudentID;

Looks like a spelling mistake. Shouldn't it be tblStudent in that last WHERE clause?

 

[KodeKing]

All I can say is MUPPET

Thanks alot