Dropdownmenu's linked?

I've got a first dropdown menu (tableform) having the letters A,B,C... , secondly I have a dropdownmenu wit开发者_如何转开发h in tableform as well (so you can't type any wrong words) for instance Bird, Beast, ..., Duc... What I want is that the second dropdownmenu is just concentrated to the first letter I choose. How do You do that?

In the after update of the first combo box, go:

Dim Sql as string

Sql = "select Animal from tblAnimals where Animal like '" & me.combo1 & "*'"
Me.ComboBox2.RowSource = sql