On a form in Access, how do I make one list drive the options ava.

W

Winkleby

I want to be able to have the selection in one list drive the options
available in the next selection list. How can I do this?
 
S

Sprinks

Hi, Winkleby.

In the AfterUpdate event procedure of the first combo box, set the RowSource
property of the second, using a WHERE clause that refers to the selected
value. Something like:

MySecondComboBox.RowSource = "SELECT MyTbl.ID, MyTbl.Desc from MyTbl WHERE
MyTbl.ID = " & Me!MyFirstComboBox.Value

Hope that helps.
Sprinks
 
Top