lookup value for combo box based on another combo box value?

[Guest]

I have a form that stores data into a table. I have added a combo box that
list book chapters from another table. I want to add another combo box that
will present subchapters from a subchapter table but only the subchapters
that are related to the chapter selected in the first combo box. Both the
chapter and subchapter tables are using primary keys that are auto numbers,
and the subchapter table has a field using the primary key from the chapter
table as an orphan key for relational database value. I'm not sure how to get
one field to present data based on the selection of a prior combo box
selection? I hope someone can help me sort out this confusing situation!!

 

[Roger Carlson]

This is generally called a "cascading combo box". On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"CascadingComboBoxes.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

David,

This is a frequent question. Search the forum for "Cascading Combo Boxes".
Basically, you use the first combo box' AfterUpdate event to change the
RowSource property of the 2nd, and requery it.

Hope that helps.
Sprinks