filtered listbox on subform

[ebjers]

I have a form with a listbox to select records from one table, the list box has Project_ID (PK, hidden) and Project_Name
There is a subform with another listbox pulled from another table that has; Office_ID (PK, hidden), Project_ID (FK, Hidden), Office_name


The forms are linked on Project_ID

The record selector for the sub form shows the correct number of records and cycles through the related records


The listbox on the subform shows all records in the table and not just the ones related to the selection in the parent form

What do I need to change so the listbox on the subform only shows the records based on the selection in the listbox in the parent form?

[ranman256]

you are doing this backwards. Why not put the subform listbox on the MAIN form, if you want to filter the main form?

but you can filter anything by just using the full path (see builder)

me.filter = "[field]=" & forms!myform!subForm!form.listbox2
me.filterOn = true

[ebjers]

you are doing this backwards. Why not put the subform listbox on the MAIN form, if you want to filter the main form?

but you can filter anything by just using the full path (see builder)

me.filter = "[field]=" & forms!myform!subForm!form.listbox2
me.filterOn = true

Hello Ranman256,

I am trying to filter the listbox on the subform based on what is selected in the parent form not to filter the listbox on the parent form.

Where do I apply those filters?

[orange]

ebjers,

Please tell us more about "your business" in simple terms. You have Projects and Offices. How are Offices and Projects related? Forget forms and listboxes for the moment and, using simple English -no jargon, tell us about an Office(s) and a Project.

[ebjers]

ebjers,

Please tell us more about "your business" in simple terms. You have Projects and Offices. How are Offices and Projects related? Forget forms and listboxes for the moment and, using simple English -no jargon, tell us about an Office(s) and a Project.

Each project can have one or more offices
Each office can be related to only one project
There may be more than one office in the same city for different projects so office name is not unique in the database but the office ID (PK in office table) is unique

[June7]

This is cascading or dependent combo/list box - a common topic. Need a WHERE clause in the offices listbox that references projects listbox. Then need code that requeries the offices listbox. Probably need in projects AfterUpdate event as well as the subform Current event.

What is purpose of offices listbox? Is it BOUND?