Solved

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

Posted on 2008-10-29
2
198 Views
Last Modified: 2013-11-28
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 -
0
Comment
Question by:EzlyAmuzed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 42

Accepted Solution

by:
dqmq earned 50 total points
ID: 22836911
I suggest the recordsource of your mainform is based on the StudentTable.  On that form you can use the built in navigation controls, combo boxes, or any number of other means to make a given student current.

Add a subform control and base the subform on StudentSession. This would be your session documentation form.  In the subform control properties you can link the studentsession form to the student form.  
0
 
LVL 4

Expert Comment

by:OdeMonkey
ID: 22965962
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.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question