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
195 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now