给你一个例子,你自己该把
Public Sub CmbShopList(CmbName As ComboBox) '店铺
Dim strSql As String
If rsClass.State Then rsClass.Close
strSql = "SELECT a.ShopNo,a.Name FROM Etam.dbo.EtamShop a ORDER BY a.ShopNo"
rsClass.Open strSql, Cn, adOpenStatic, adLockReadOnly
With CmbName
.Clear
Dim i As Integer
i = 0
Do While Not rsClass.EOF
.AddItem Right("0000" + CStr(rsClass!shopno), 4) + " - " + IIf(IsNull(rsClass!Name), "", Trim(rsClass!Name))
.ItemData(i) = rsClass!shopno
i = i + 1
rsClass.MoveNext
Loop
.ListIndex = 0
End With
End Sub
在ACCESS中做Combobox能通过Select语很容易地做一个下拉框显示两列,但只取其中的一列值,在VB中不知道如何做,各位能否指点一下,或给个代码什么的。谢谢
******************************************************************************
Dim Sql As String
Dim x() As String
x = Split(ComboBox.Text)
'取第一列:
Sql = "Select * From TableName Where UserID = '"& x(0) &"'"
'取第二列:
Sql = "Select * From TableName Where UserName = '"& x(1) &"'"