Private Sub Combo2_GotFocus()
Call openconn
Dim rs As New ADODB.Recordset
rs.Open "select * from lxmc where trim((lxmc.基层)) = '" + Combo1 + "', Conn, adOpenKeyset, adLockOptimistic
Do While Not rs.EOF
Combo2.AddItem rs.Fields("路线名称").Value '这样就添加到组合框
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
End Sub
我的想法是利用combo1的值对路线名称进行帅选,符合基层=combo1的路线出现在combo2中。谢谢!
rs.Open这句话不知道错在哪里?
Call openconn
Dim rs As New ADODB.Recordset
rs.Open "select * from lxmc where trim((lxmc.基层)) = '" + Combo1 + "', Conn, adOpenKeyset, adLockOptimistic
Do While Not rs.EOF
Combo2.AddItem rs.Fields("路线名称").Value '这样就添加到组合框
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
End Sub
我的想法是利用combo1的值对路线名称进行帅选,符合基层=combo1的路线出现在combo2中。谢谢!
rs.Open这句话不知道错在哪里?
还有,我觉得where 后面的条件要用括号括起来。具体如下:
rs.Open "select * from lxmc where (trim((lxmc.基层)) = '" + Combo1 + "')", Conn, adOpenKeyset,
用这一句
rs.Open "select * from lxmc where 基层 = '" & trim(Combo1) & "', Conn, adOpenKeyset, adLockOptimistic