Combo Box Filters for custom navigation

[hobsondm01]

This problem has been niggling away at me for a while now.

I have created an extensive database that holds all the data for my companies product base.
There are 4 tables that all tie in to 1 form. Each record is one product.

I currently have 2480 products, therefore 2480 records.

My issue is that I have no decent way of navigating through the records.
Im running Access 2007.

All the data is there for it i just dont know how to utilise it.
Here is an example row of the main product table.

Product Type | Product Section | Product Sub-Section | Item Name

Its a perfect product tree. Section > Sub-section>sub-sub-section.

What i want is to be able to have three drop down boxes so when i pick a product type in the first one, only the sub sections of under that are available to click in the 2nd one, then when i pick a sub section, only the sub-sub sections are available in the 3rd one.
Then once the criteria is selected, it will show me (somehow, a report or in a datasheet) the records that apply to those filters.



Ive been trying to find a solution but this seems to incorporate a lot of aspects of access of which i have limited knowledge.
i wondered if anyone knows of any way of doing this?
Just some guidance or even some code i can manipulate to meet my ends.

I would appreciate any help.

Thanks

[pbaldy]

The concept is often called cascading combos:

Baldy-Cascading Combos

Opening a form/report could be done with this technique:

BaldyWeb wherecondition