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

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

Guest

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