Private Sub Combo1_Click()
Dim dy As New ADODB.Recordset
dy.Open "select 课程 from 年级表 where [年级] ='" & Combo1 & "'" , cn, adOpenDynamic, adLockOptimistic
combo2 =dy("课程")
dy.close
endsub
Combo1.AddItem "年级1"
Combo1.AddItem "年级2"
Combo1.AddItem "年级3"
这两局是加在Private Sub Form_Load()中的。