I am trying to create a Form in Access Database which has following fields: Subject_ID Date Ethnic_category Ethnic_Type Father Mother GrandPa GrandMa ------------------------------ Subject_ID  and Date  are in main form. Rest of the fields are  in sub-form Father, Mother, GrandPa, and GrandMa are check Box Ethnic_category and Ethnic_Type are Combo Box with pre-defined values are limited to following: Ethnic_Category           Ethnic_Type      Jewish              :         Ashkenazi Jewish                                         Sephardic Jewish      European         :          Northern European                                          Central European                                          Scandinavian       Asian                :        Chinese                                         Japanese                                         Thai      Latino/Hispanic     :    Mexican                                          Cuban  --------------------------------------------------- The idea of this form is to be able to store all the information into a single table and since one person's ancestry can have multiple ethnicity, we can't make Subject_ID as a primary key and should be able to store multiple rows for same SubjectID.  For example:     Subject_ID    Date          Ethnic_category     Ethnic_type        Father     Mother     GrandPa    GrandMa     1001          1/1/2011        Asian                         chinese             1              Null               1                 1     1001          1/1/2011        European                 Northern          Null             1                 Null            Null     1002          1/2/2011        Latino                        Mexican            1              1                   1                 1     1005          1/5/2011        Asian                         Thai                   1            Null              Null          Null     1005          1/5/2011        Asian                         chinese           Null             1                 Null          Null     1005         1/5/2011         Jewish                      Ashkenazi         Null            Null               1             Null     1005         1/5/2011         Latino                       cuban               Null           Null              Null             1  ---------------------------------------------------------------------------------------------------------- My problem is : I was able to input all the values of  Ethnic_Category and Ethnic_type in a combo box and it will give user  an option to select any of the pre-defined values and will store in the table but i want to control the second combo box (Ethnic_type) based upon the selection of first combo box (Ethnic_category) . For example if a person select "Asian" from the category the ethnic_type list should display only "Chinese" , "Japanese" , and "Thai" and similarly if i change it to Latino/Hispanic category it should display only Mexican and cuban and store the record after the selection is made I am a rookie when it comes to writing VB scirpts and tried some of the codes from google search but still couldn't control my combo box properly. I followed this link too but it didn't work: http://office.microsoft.com/en... any help will be greatly appreciated.  Thanks Last edited: 22-Feb-11 01:36 PM