把文本和值都取出来 private sub form_load() ...... set rs = cnn.execute("select field1, field2 from yourtable") do until rs.eof combo1.additem rs!field1 combo1.itemdata(combo1.newindex) = rs!field2 rs.movenext loop end sub选中某项时值也是对应的: private sub combo1_click() rs.find "field2 = " & combo1.itemdata(combo1.listindex) ...... end sub
cbo.additem t1,1
cbo.itemdata(1)=value1
cbo.add t2,2
cbo.itemdata(2)=value2
刚才忘了说,这样用Value必须是整数,因为ItemData是长整型数组
private sub form_load()
......
set rs = cnn.execute("select field1, field2 from yourtable")
do until rs.eof
combo1.additem rs!field1
combo1.itemdata(combo1.newindex) = rs!field2
rs.movenext
loop
end sub选中某项时值也是对应的:
private sub combo1_click()
rs.find "field2 = " & combo1.itemdata(combo1.listindex)
......
end sub
ComboBox提供的功能不足就另外想办法.