Private Sub Command1_Click()
x = InputBox("search", "enter number")
Data1.Recordset.Index = "رقم الزبون"
Data1.Recordset.Seek "=", x
With Data1.Recordset
If Data1.Recordset.NoMatch Then
Data1.Recordset.MoveFirst
MsgBox "sorry", vbOKOnly, "buy"
End If
Data1.Recordset.MoveNext
Text1.Text = Val(Text3.Text)
End With
End Sub
