J
John J.
In a field's beforeupdate I validate a value. When the value is not valid,
I'd like to change this field's value to null. However, when I try to do
that, I get an error, saying that the value can not be stored:
Private Sub test_BeforeUpdate(Cancel As Integer)
If test = 1 Then
msgbox "Wrong value"
Cancel = True
test = null
End If
End Sub
Any ideas on how to make this work?
Thank you.
John
I'd like to change this field's value to null. However, when I try to do
that, I get an error, saying that the value can not be stored:
Private Sub test_BeforeUpdate(Cancel As Integer)
If test = 1 Then
msgbox "Wrong value"
Cancel = True
test = null
End If
End Sub
Any ideas on how to make this work?
Thank you.
John