December 30th, 2012, 09:56 PM
newbie help please look...
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"
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
December 31st, 2012, 04:34 PM
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).