Warning message before update

[Dimitris Nikolakakis]

In a form I have two fields: Quantity, PackagingQty

I want to check if "Quantity MOD PackagingQty <>0" and if so to appear a
warning message (probably in BeforeUpdate)

No I have the check in Validation Rule of the field Quantity but this
prevents the record from saving. I want the user to see the message and then
decide if he wants the quantiy he entered.

thanks

 

[Wayne Morgan]

You're correct. Use the BeforeUpdate event of the control instead of the Validation Rule.

In the BeforeUpdate event try something like:

If Me.Quantity MOD Me.PackagingQty <> 0 Then
If Msgbox("Do you want to use this value?", vbYesNo + vbQuestion) = vbNo Then
Cancel = True
Me.ActiveControl.Undo
End If
End If