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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
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
 
Back
Top