7,763
社区成员
发帖
与我相关
我的任务
分享
Dim s As Integer
Dim n As Integer
Private Sub Command1_Click()
Adodc2.Recordset.MoveFirst
Adodc2.Recordset.Find "书名=" & " '" & Text1 & " '"
If Adodc2.Recordset.EOF Then
MsgBox "无此书!", , "提示"
Else
s = Val(InputBox("请输入销售图书的数量", , "请输入销售数量"))
n = Adodc2.Recordset.Fields("入库数量")
Adodc2.Recordset.Fields("入库数量") = n - s
End If
End Sub
Private Sub Command2_Click()
Form16.Hide
Form3.Show
End Sub