If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating form with selections that change based on user's previous selection
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. |
#2
|
|||
|
|||
creating form with selections that change based on user's previous selection
Do a search on cascading comboboxes.
This has bee asked and answered in here many many times. "Robert Bogart" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|