Re: Filtering records with combo box

From: Bruce (anonymous_at_discussions.microsoft.com)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 07:33:57 -0700

If the complexity comes from applying a succession of
filters, I can do without that refinement. My main
objective is to filter records based on a combo box
selection, then to navigate through the found records. My
main discovery so far is that I do not want the key column
in the combo box row source. Thank you for the letting me
contact you directly. I am continuing to experiment, but
if I still come up short I will be taking you up on the
offer soon.
>-----Original Message-----
>Your problem is possibly a little too complex to be
>answered in this forum.
>If you would like to contact me directly on
>
>chris
>at
>mercury-projects
>dot
>co
>dot
>nz
>
>I may be able to help.
>
>>-----Original Message-----
>>I have a database to keep track of training records.
>Each
>>training session is unique, and each is attended by from
>>one to seventy people. Each employee will attend
>multiple
>>training sessions each year. I have handled this with
an
>>Employees table, a Sessions table, and an Attendance
>table
>>as a junction table.
>>I use a form for entering the Session information
>>(Subject, Relevant Document, Department, etc.) into the
>>Sessions table. I use a subform for entering attendance
>>(Name, Date) into the Attendance table. When I open the
>>form, I can scroll through the training sessions and
>learn
>>who was at each one. It works perfectly, as far as it
>>goes.
>>Now I need to find a Sessions record based on one of
>>several criteria. For instance, I need to see all of
the
>>records for a department. I can make a combo box based
>on
>>the Sessions table, but of course that shows me only a
>>listing of departments, some appearing many times.
>>Clicking any item on the list shows me only a single
>>record. I need to be able to select a department, then
>>use navigation command buttons (arrows) on the form to
>>scroll through all of the Sessions records that have
that
>>department in the appropriate field. In other words, I
>>need to filter the records based on the combo box
>>selection, and be able to scroll through the filtered
>>records.
>>One more thing I hope to do: filter by multiple
>criteria,
>>preferably in any order. I can set up several combo
>boxes
>>so that I can search by a choice of fields, but can one
>>selection be made to restrict the choices in the next
>>combo box, and does such filtering need to happen in a
>>particular order? If this is complex I can do without
>it,
>>but it could come in handy.
>>.
>>
>.
>