form showing list based on values of combo boxes

[Khalil Handal]

Hi,
I have a bounded for that shows a list of names. The form has three combo boxes: cboYears, cboLevels and cboSections.


I want the list to show only the names based on the combo boxes values (to show the names of a specific year and specific level and specific section).
How can I do this?

Note:
The form has also a subform to show more information about the selected name form the list.


Khalil

[Minty]

This sounds like a term called cascading combo's.

Paul has a example here http://baldyweb.com/CascadingCombo.htm

[Khalil Handal]

Hi,
It is not cascading combo's, It it three criteria together, each value of the criteria is selected from a combo box.
To explain more:
I have people added to the database each year, they are divided into groups and each group have sections. So for example, I need to select people from the year 2019, group name is Flowers and section B.

Khalil

[June7]

Review http://allenbrowne.com/ser-62.html

[Welshgasman]

Build the recordsource for the listbox, from the combo values. You need to decide when it is activated, a button perhaps?

[Khalil Handal]

Hi,
I have Review http://allenbrowne.com/ser-62.html
I used it as an example and built my code. The string strWhere shows the correct values from the three combo boxes.

In Allen Browne example the code applies the filter to the form as in the following two line:

'Finally, apply the string as the form's Filter.
        Me.Filter = strWhere
        Me.FilterOn = True

I need to apply the the filter for the List Box in the main form. The form also contains a sub form.
How can I do this?

Khalil

[Welshgasman]

Hi,
I have Review http://allenbrowne.com/ser-62.html
I used it as an example and built my code. The string strWhere shows the correct values from the three combo boxes.

In Allen Browne example the code applies the filter to the form as in the following two line:

'Finally, apply the string as the form's Filter.
        Me.Filter = strWhere
        Me.FilterOn = True

I need to apply the the filter for the List Box in the main form. The form also contains a sub form.
How can I do this?

Khalil

https://www.access-programmers.co.uk...-query.245604/