newbie help please look...

[jeffrey159]

so i'm creating a access with a question saying the quantity must not exceed 10 if it exceed, then it will have a msgbox saying exceeded

this is my code for my sell button

Private Sub Sell_Click()

Me.Quantity.DefaultValue = 1
If Me.Quantity.Value > 10 Then
MsgBox "exceeded limit"
End If
End Sub

i don't understand, quantity value greater than 10 then msgbox exceeded limited. what's wrong with it? it doesn't show any msgbox when i press sell
but when i put vault smaller than 10. it shows the msgbox... please help

[meratigoerr]

Doesn't seem to be any reason why it would do that, unless in your code you had your less than instead of greater than. Post a stripped down version of your database so we can take a look. (remove any data you may not want to share).