Set Combo Box source based on the value of another Combo Box

[bconner]

I want to set the RowSource of a ComboBox based on what the value is in another ComboBox. Example:

Select Case ComboBox1
 
   Case "CodingList"
      ComboBox2.RowSource = QryCodingList
   Case "DataEntryList"
      ComboBox2.RowSource = QryDataEntryList
   Case "UserList"
      ComboBox2.RowSource = QryUserList
 
end Select
 
Basically I want the Lists available in ComboBox2 to change based on the Value in ComboBox1

 

[pbaldy]

You haven't said what the problem is, but try

ComboBox2.RowSource = "QryCodingList"