Searching for records in a database

[NewtoV]

I am trying to search for matching records in a database. Example: I search the student number 10000, if it matches a student it brings up information about the student(name, age etc.) If it doesn't match, I tell the user that it has no matches.

EDIT: got some help from professor, not sure what panStudentRecord is for? and why it doesent work as is.

EDIT: Figured it out, he meant for us to use a panel to contain the student info, the pantStudent line was to make it visible

TblStudentsBindingSource.Filter = "StudentNumber =" & txtStudentNumber.Text

        If TblStudentsBindingSource.Count = 1 Then
            panStudentRecord.Visible = True
        End If
    End Sub