Filling in a SubForm based on 3 Cascading Combo Boxes

[Nanette]

I have a form with 3 unbound Cascading Combo Boxes (thanks to everyone for
helping me get this far!!). On this form I have a sub form that gets its data
from a table (as usual).

I would like to have the subform get the table data based on the chosen
criteria in the Cascading Combo Boxes.

What is the correct name for what I want to do?

And, any suggestions on how to do it or where to research it?

 

[Damian S]

Hi Nanette,

I am assuming you mean you want to filter your subform based on the
selections in the cascading combos.

Searching on Filter should find you plenty of options... but basically if
you can have blanks in the combos, you will need to create your where clause
using a series of if then or case statements, then use something like this:

me.SUBFORMNAME.form.filter = WHERECLAUSE
me.SUBFORMNAME.form.filteron = true

Hope this points you in the right direction.

Damian.