给你一个例子 不知道是否算是你想要的 Public Sub CmbClass(ByVal ClassSort As String, CmbName As ComboBox) '从参数表取出信息放到ComboBox控件中 Dim strSql As String If rsClass.State Then rsClass.Close strSql = "SELECT a.Code,a.Description FROM TransParameter a " _ & "WHERE a.Class='" & ClassSort & "'" rsClass.Open strSql, Cn, adOpenStatic, adLockReadOnly With CmbName .Clear Dim n As Integer n = 0 Do While Not rsClass.EOF .AddItem Trim(rsClass!Description) .ItemData(n) = Trim(rsClass!Code) n = n + 1 rsClass.MoveNext Loop .ListIndex = 0 End With End Sub
'向Combox里添加数据 Public Sub Main() Dim str As String str = "SELECT b FROM a " rs.Open str, Cn, adOpenStatic, adLockReadOnly With Combo1 .Clear Do While rs.EOF<>true .AddItem Trim(rs!b) rsClass.MoveNext Loop .ListIndex = 0 End With End Sub
不知道是否算是你想要的
Public Sub CmbClass(ByVal ClassSort As String, CmbName As ComboBox) '从参数表取出信息放到ComboBox控件中
Dim strSql As String
If rsClass.State Then rsClass.Close
strSql = "SELECT a.Code,a.Description FROM TransParameter a " _
& "WHERE a.Class='" & ClassSort & "'"
rsClass.Open strSql, Cn, adOpenStatic, adLockReadOnly
With CmbName
.Clear
Dim n As Integer
n = 0
Do While Not rsClass.EOF
.AddItem Trim(rsClass!Description)
.ItemData(n) = Trim(rsClass!Code)
n = n + 1
rsClass.MoveNext
Loop
.ListIndex = 0
End With
End Sub
Public Sub Main()
Dim str As String
str = "SELECT b FROM a "
rs.Open str, Cn, adOpenStatic, adLockReadOnly
With Combo1
.Clear
Do While rs.EOF<>true
.AddItem Trim(rs!b)
rsClass.MoveNext
Loop
.ListIndex = 0
End With
End Sub
rs.fields.item("b").value=combo1.text
具体添加到数据库中的哪个字段的哪个位置,你自己再改一下吧