creating form with selections that change based on user's previous selection

[Robert Bogart]

I'm building a database to track articles for a
newsletter. The articles deal with various court cases and
fall into one of four major categories. These four
categories are themselves sub-divided into from six to 19
sub-categories. I would like to create a form that would
allow the user to select one of the four main categories
and then make a selection from one of the related sub-
categories. Can anyone make any suggestions? I thought a
sub-form, but I'm drawing a blank here on how to execute
this. So far, I've created tables for (1) main categories
(one table) and (2)each of the sub-categories (four
tables).

I'd appreciate any suggestions as to how to make this
dynamic action occur on the form. Needless to say, I need
to have the data on the form write to a master table that
contains a field for the main category and one for the sub-
category.

Thanks much.

 

[Rick B]

Do a search on cascading comboboxes.

This has bee asked and answered in here many many times.


I'm building a database to track articles for a
newsletter. The articles deal with various court cases and
fall into one of four major categories. These four
categories are themselves sub-divided into from six to 19
sub-categories. I would like to create a form that would
allow the user to select one of the four main categories
and then make a selection from one of the related sub-
categories. Can anyone make any suggestions? I thought a
sub-form, but I'm drawing a blank here on how to execute
this. So far, I've created tables for (1) main categories
(one table) and (2)each of the sub-categories (four
tables).

I'd appreciate any suggestions as to how to make this
dynamic action occur on the form. Needless to say, I need
to have the data on the form write to a master table that
contains a field for the main category and one for the sub-
category.

Thanks much.