End Sub
这是组合框的代码,不是绑定的啊作者: Henry D. Sy 时间: 2012-9-26 14:11
gzkrmch 发表于 2012-9-26 13:34
Private Sub 商品名称_AfterUpdate()
Me.商品编号 = Me.商品名称.Column(1)
??作者: gzkrmch 时间: 2012-9-27 11:38
Henry D. Sy 发表于 2012-9-26 14:11
??
Option Compare Database
Private b
Private Sub 堆头陈列商品_Change()
Dim a As String
a = "*" & Me.堆头陈列商品.Text & "*"
Me.堆头陈列商品.RowSource = "SELECT 商品ID, 货品编号 FROM 商品目录 Where 货品编号 like '" & a & "';"
Me.堆头陈列商品.Dropdown
b = Me.堆头陈列商品.Column(0, 0)
End Sub
Private Sub 堆头陈列商品_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyUp, vbKeyDown
Me.堆头陈列商品.OnChange = ""
Case Else
Me.堆头陈列商品.OnChange = "[Event Procedure]"
End Select
End Sub
Private Sub 堆头陈列商品_NotInList(NewData As String, Response As Integer)
Dim ctl As Control
Set ctl = Me!堆头陈列商品
Response = acDataErrContinue
ctl.Undo
Me.堆头陈列商品 = b
Me.堆头陈列商品.RowSource = "SELECT 商品ID, 货品编号 FROM 商品目录;"
SendKeys ("{Tab}")