CANCEL = TRUE works in BeforeUpdate event.
How does having code in general module prevent tampering?
CANCEL = TRUE works in BeforeUpdate event.
How does having code in general module prevent tampering?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Instead of sub make it a function, which returns True when update must be canceled, and False when updating must be proceed. Then
But having the check in separate function is useful only, when you can call it from several events (e.g. BeforeUpdate events of sevaral forms).Code:Private Sub Form_BeforeUpdate(Cancel As Integer) Cancel = CheckForCancel()) End Sub
Instead of sub make it a function, which returns True when update must be canceled, and False when updating must be proceed. Then
But having the check in separate function is useful only, when you can call it from several events (e.g. BeforeUpdate events of sevaral forms).Code:Private Sub Form_BeforeUpdate(Cancel As Integer) Cancel = CheckForCancel()) End Sub
Thanks a lot!!! GOD BLESS YOU!!!!!!!!