Suppress subform before update event with button

[Neruda]

Hi,
when a continuous subform before update event is triggered because a textbox in it is blank, is there any way to still be able to click a button on the parent form to escape the event (bit like using the escape key but using a button) ?

Thanks

[Neruda]

Well,
the answer I found is no.Had to take a good look at events, slowly they are getting in my dense brain. The form is now working!!

[NeoPa]

What you describe is impossible. The Form's BeforeUpdate event is triggered by some form of save being activated. It cannot possibly be triggered by a TextBox being empty. It can behave in a particular way depending on the contents of a TextBox but certainly not triggered by it.

It's very difficult to give meaningful answers when the question doesn't make sense. You'll find far more answers to questions if you make the effort to tell us what the issue is more clearly and accurately. I understand that may be due to English being a foreign language but the clearer the question the better help you'll get for sure.

You may be looking for the .Undo method. It's hard to be sure in the circumstances.

On the other hand, when you find yourself having to do things the hard way and research for yourself, you often find you understand things a lot more clearly in the end.

[Neruda]

Thanks NeoPa, spent the last week going through a form events; bit clearer now.
What I wanted to ask was this:
when a Subform is saved the beforeUpdate event is triggered, in this case it won't let me continue unless the textbox has something in it. I wanted to have a button on the Form that can be pressed even if that textbox is empty. But that can't be done. The .undo is just what I have done, you guessed right. Thanks

Private Sub Form_BeforeUpdate(Cancel As Integer)
    On Error GoTo ErrorHandler
 
 
 
        If IsNull(Me.txtPaymentAmount) Then
            MsgBox "Amount needed", vbCritical, "ccPOS"
            Cancel = True
        End If
 
 
ExitSub:
    Exit Sub
ErrorHandler:
    MsgBox "Error No: " & Err.Number & vbNewLine _
         & "Error Details: " & Err.Description & vbNewLine _
         & "Error in Sub: frmPaySbf\Form_BeforeUpdate"
    Resume ExitSub
End Sub

[NeoPa]

I'm glad I could help. I do try. Sometimes I struggle to understand what is required from the wording but I always try if I can.