Combo box data selection

[mmmk]

I am creating a db with tables Area and Sub_Area. In my form I have combo boxes which list the data in each table. I have been asked to configure the combo boxes so that when a user selects "Technology" from the Area combo box, only the Sub_Areas related to "Technology" will be displayed in the Sub_Area combo box. So instead of 10 sub_areas to choose from, the user would only see the sub_areas related to the area they chose. Is this possible? Let me know if I need to clarify anything.
Thanks.

 

[pbaldy]

Sounds like you're looking for this type of thing:

http://www.baldyweb.com/CascadingCombo.htm

 

[mmmk]

Thanks! This is exaclty what I'm looking for. Could you help me make sense of the code? I am having trouble applying it to my db.

 

[pbaldy]

Exactly which part is not making sense?

 

[mmmk]

Well, pretty much all of it. I need a table that only holds the area and related sub_area? Then I build a query off this table? This query put data into the sub_area combo? I've been searching alot and think I confused myself even more.

 

[mmmk]

I think i got it.