On my form i have text box where the user enters a given quantity.
The text box is called 'remake number'. I would like to set the text box up so when a number is entered that is greater than 10,000 a message box appears and says: 'quantity greater than 10000 - is this correct'?.
The message box should have a yes and no button. If no is selected the operator can re enter the number.
Private Sub remake_number_AfterUpdate()
If Val(Nz(Me.remake_number.Value)) > 10000 Then
If MsgBox("'quantity greater than 10000 - is this correct?", vbQuestion + vbYesNo, "remake_number") = vbNo Then
Me.remake_number.Value = Null