Dependent lists in Combo Boxes

[DeLaMartre]

My efforts to find a solution to my problem in my books have failed, so I am asking for help.

I would like to set up an Access db such that the choices which appear in a combo box are dependent on the choice made in a previous combo box.

For instance, if "Major" and "Minor" are the only two choices in the first combobx, the one you choose affects the choices you will be given in a second combobx.

Any help will be greatly appreciated!

Thanks very much,

-Bob in California

 

[llkhoutx]

The rowsource for the second combo box has the contents of the first combobox as a criteria, i.e.

me!combobox2.recordsource="Select ... where [commonfield]="
_ & me!cmobobox1
me!combobox1.requery

 

[DeLaMartre]

Thanks very much for your help, Texas! Your time is appreciated!