VB combobox控件的用法
我想用VB 的combobox控件 连access表中的几张数据表
如 供应商 订单 商品 销售表
用combobox 控件显示上面四个词, 然后在MSHflexgrid上显示上面四个词的表的内容
求教 各位大神 谢谢!
本人新手 这是我写的代码 求指点
Private Sub Combo1_Change()
If Combo1.Text = "供应商" Then
Adodc1.RecordSource = "select * from SUPPLIER"
Adodc1.Refresh
End If
If Combo1.Text = "订单" Then
Adodc1.RecordSource = "select * from PURCHASE_ORDER"
Adodc1.Refresh
End If
If Combo1.Text = "商品" Then
Adodc1.RecordSource = "select * from GOODS"
Adodc1.Refresh
End If
If Combo1.Text = "销售表" Then
Adodc1.RecordSource = "select * from SALE_TABLE"
Adodc1.Refresh
End If
End Sub
Private Sub Form_Load()
Dim A As Integer
na(0) = "供应商"
na(1) = "订单"
na(2) = "商品"
na(3) = "销售表"
For A = 0 To 3
Combo1.AddItem na(A)
Next A
Combo1.ListIndex = 0
End Sub