代码写到keydown事件
If e.KeyCode = Keys.Enter Then
Dim Filter As String
With e.Form.Controls("TextBox1")
If .text IsNot Nothing Then
Filter &= "助记码= '" & .text & "'"
Filter &= " or 条形码= '" & .text & "'"
Filter &= " or 商品名= '" & .text & "'"
Filter &= " or 自编码= '" & .text & "'"
Filter &= " or 商品号= '" & .text & "'"
End If
End With
If Filter > "" Then
Tables("商品资料表").Filter = Filter
Else
Tables("商品资料表").Filter = ""
End If
e.cancel = True
Dim r As Row = Tables("商品资料表").Current
If r Is Nothing Then
msgbox("没有该商品")
Else
If Forms("入库窗口").Controls("TextBox1").Text ="" Then
Return
'返回
Else
Dim ndr As DataRow = DataTables("商品入库表").AddNew
ndr("商品号") = r("商品号")
ndr("商品名") = r("商品名")
ndr("条形码") = r("助记码")
ndr("助记码") = r("助记码")
ndr("自编码") = r("自编码")
ndr("规格") = r("规格")
ndr("单位") = r("单位")
ndr("生产单位") = r("生产单位")
ndr("单位") = r("单位")
ndr("批文") = r("批文")
ndr("入库号") = e.Form.Controls("TextBox2").text
ndr("数量") = e.Form.Controls("TextBox3").text
ndr("单价") = e.Form.Controls("TextBox4").text
ndr("入库金额") = e.Form.Controls("TextBox5").text
ndr("入库日期") = e.Form.Controls("DateTimePicker1").Value
End If
End If
End If