newbie table set-up combobox

[littleme]

I'm not sure if this is the right forum. Am new to this wonderful world of Access .
I have 4 tables:
tblSurface: fldCodeID, fldSurfaceExp
tblResult: fldResultID, fldResultExp
tblQuality: fldQualityID, fldQualityExp
tblColor: fldColorID
These tables are used in combobxes on a “help form” to help users create a painting code (don’t ask) which is AfterUpdate moved to query that populates ComboboxPaint in another form. Users choose code appropriate for a certain room. (again.. don’t ask)
Would like it so that depending on what Surface is selected in comboboxSurface, certain choices are available in comboboxResult, and depending on choices there, certain choices available in comboboxQuality and comboboxColor.
Would also like the corresponding Explanation to each combobox choice to show in a textfield after combobox choice.
How would I best set that up so that it’s easy to add to the above table as time goes on? How do I limit what choices from comboboxSurface/tblSurface go with which Result?

Grateful for any tips.

 

[DCrake]

You need to search for cascading combo boxes for help on this matter.

 

[littleme]

Sorry havent gotten back to you earlier. Thank you!

 

[boblarson]

And just in case, here's a sample:
http://downloads.btabdevelopment.com/Samples/combos/CascadingCombosSample.zip