<div>
Populate a combo box, cbxSelectStudent, (at the top of your form) with the alpha list of students. &nbsp;Set up the AfterUpdate event to set the recordsource for the form to something akin to &quot;SELECT * FROM tblStudentNotes WHERE StudentID=me.cbxSelectStud<wbr />ent.Value.<wbr /> &nbsp;Then requery the form.
</div>


Populate a combo box, cbxSelectStudent, (at the top of your form) with the alpha list of students.  Set up the AfterUpdate event to set the recordsource for the form to something akin to "SELECT * FROM tblStudentNotes WHERE StudentID=me.cbxSelectStudent.Value.  Then requery the form.

<div>
<div class="content wysiwyg-content">
I have created this database to record session notes for students. Each student has a student number and a note for each session. I have a session documentation form. I want to filter the form for a specific student and only recall those records for a particular student, sorted by date. Then I want to add a new record. I'm sure that this is simple but I am struggling. I can do this with the filter function but now my colleagues want to use the database and it would be much easier for them to have a find student button - thanks so much - 
</div>
</div>


I have created this database to record session notes for students. Each student has a student number and a note for each session. I have a session documentation form. I want to filter the form for a specific student and only recall those records for a particular student, sorted by date. Then I want to add a new record. I'm sure that this is simple but I am struggling. I can do this with the filter function but now my colleagues want to use the database and it would be much easier for them to have a find student button - thanks so much - 

How do I create a combobox to filter records in a Access 2007 form - returning mutliple records for one distinct number?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.