In my small application There is a text box called TAKE OUT where user can enter a value and click the button so it will be deduced from the Quantity text box (Which is bound to the database) and this should happen only if the TAKEOUT value is smaller than the quantity other wise a message should appear I added the following code to the button but it always gets the message (even if the take out value is smaller)
If Me.txt_OUT.Value > Me.txt_qty.Value Then
MsgBox ("Stock quantity not enough")
Else
Me.txt_qty.Value = Me.txt_qty.Value - Me.txt_OUT.Value
Me.txt_OUT.Value = ""
End If
Please help me I'm new to access
If Me.txt_OUT.Value > Me.txt_qty.Value Then
MsgBox ("Stock quantity not enough")
Else
Me.txt_qty.Value = Me.txt_qty.Value - Me.txt_OUT.Value
Me.txt_OUT.Value = ""
End If
Please help me I'm new to access