Cascading Combo Boxes 4 Nodes Deep

[MikeNificent]

Hi There, I am a complete noob at access and VBA coding so I'm going to be as descriptive and as staight to the point as I can be about my problem's simplicity in all complexity. I am creating a self service system for employees to update there location status.

Basically an employee will select "Campus" then "Building" then "Floor" then "Room"

Below is a shortened version of the table I'm using: (well as short as it can be for you to understand why hense in the heading 4 nodes deep)

Campus-- Building -------------------- Floor --------------- Room
DFC ------ DFC - John Orr Building - Ground ------------ G120A1
DFC ------ DFC - John Orr Building - First ---------------- 1107
DFC ------ DFC - Civil Eng Building - Ground ------------ CE-G03
DFC ------ DFC - Civil Eng Building - First ---------------- CE-102
APK ------ APK - Core 1 -------------- Ground ------------- K1-G04
APK ------ APK - Core 1 -------------- First ----------------- K1-102
APK ------ APK - A-Ring --------------- First ---------------- A-103
APK ------ APK - A-Ring --------------- Second ------------ A-202
APB ------ APB - Security Office ----- Ground ------------ SO-G01
APB ------ APB - Security Office ----- First ---------------- SO-101
APB ------ APB - Fada Building ------ Lower Ground 1 - FAD-L37A
APB ------ APB - Fada Building ------ Ground ------------ FAD-G001
SWC ----- SWC - Academic D & E -- Ground ------------ ACD-104
SWC ----- SWC - Academic D & E -- First ---------------- ACD-203
SWC ----- SWC - Admin A ----------- Ground ------------ ADA-102
SWC ----- SWC - Admin A ----------- First ---------------- ADA-201

For each selection in the hierarchy (left to right) the next combo box will show only the relevant information and so on, 4 combo boxes in all.

I hope somebody can help with this. Thanks in advance.

 

[MikeNificent]

Oh and sorry I found very helpfull info from fontstuff.com on the subject but only goes up till 2 nodes deep, that goes for most I could find... It's never more than 2 nodes :-(

 

[moishy]

You will find two complete articles with samples explaining all you need to know (and much more) at the following links.
Unfortunately it requires a paid membership, but I think they do have a free trial.

Cascading Combos
Cascading Combos on Continuous Forms and Datasheets