Make the data on a box dependent on another box in the same form

[Rene']

I have two combo boxes in a form. One box contains three problem areas. The
second form has a long list of problem types. I want the second box to list
the problem types depending on what is picked in the first box. For example:
Problem Area:
Inside
Outside
Other

Problem Type:
bad
good
dingy
dirty
clean
grass
etc.

If I choose outside I only want displayed bad, dingy, or grass.

I have created a table for both problem area and problem type. Problem area
has an ID associated with it and is also included in the problem type with
each ID number besides the corresponding problem type.

 

[Linq Adams via AccessMonster.com]

Google or search here for Cascading Comboboxes, which is what this concept is
called. You should get more hits than Bill Gates has dollars!